SQL Server Date/Time Debugging Gotcha
Debugging SQL Server stored procedures is normally a straightforward operation. Even so, it’s possible to be taken down the wrong path by the SQL Profiler and SQL Server Management Studio. Assume a web page is receiving an exception calling a stored procedure that accepts a datetime field as a parameter. …