From https://connect.microsoft.com/SQLServer/feedback/details/798562/add-auto-refresh-option-for-reports-on-manage-report-page-to-report-manager Thanks for your feedback! When the report is going through the actual Report Viewer (e.g. Report Manager), we … More
Category: SQL
When is your code done? When you finish the refactor refactor refactor rule.
Since unit test cases should be written before the actual code, you cannot say that code is done when the … More
A Well needed Foreign key query for T-SQL
What is one of the biggest pains of troubleshooting data manipulation in a database? Foreign key constraints. So one guys … More
More on T-SQL DateTimeOffset, DatePart,ToDateTimeOffset, SwitchOffset and Timezones
SELECT CAST(‘2007-05-08 12:35:29.1234567 +12:15’ AS datetimeoffset(3)) AS ‘datetimeoffset’ ,DATEPART(tz,CAST(‘2007-05-08 12:35:29.1234567 +12:15’ AS datetimeoffset(3))) AS ‘timezoneoffset’ ,TODATETIMEOFFSET(CAST(‘2007-05-08 12:35:29.1234567’ as datetimeoffset(3)), 735) … More
Incrementing ID on a SQL row that you cannot use the Identity property with.
This is most common when the identity is not the primary key, and is tracked independently for each Foreign Key … More