SQL Server video to test what an application would do in the past or in the future

By:   |   Comments   |   Related: > Testing

Problem / Solution

Testing T-SQL application code that has time dependencies can be a very difficult and error prone task. By borrowing a technique from Test-Driven-Development and using a mock-time instead of the real time it becomes easy to test how a stored procedure or function would behave at some other time in the past or the future. This is done by replacing calls to getdate() from within application code with a function that returns the mock-time when run during a test.

Key Learning Items
  • How to create your own current date/time using a date in the past or future
  • Learn about CONTEXT_INFO()
Read Companion Tip

Click Here

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Andy Novick Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms