-
Recent Posts
Recent Comments
- Brian Webb on Went back to FB and realized that it was a mistake.
- Brian Webb on So do you hate the truth, or are you waking up?
- Someone at MS reads my blogs | Brian By Experience on When to use IDisposable
- Brian Webb on Your own plugin lib for your .NET application
- Distances travelled on the wrong paths | without sin on Distances travelled on the wrong paths
Archives
Categories
Meta
-
If you like my rants and rambles, feel free to contribute by sending your spare crypto currency coins to:
- BitCoin: 13zcxfCZrdatq12hKtnZ4VXYeTUoRrmW1v
If you like donating to a worthy cause, then please also donate to: Adam's The Freedom Line
Brian By Feed
Category Archives: SQL
Why hasn’t MS updated the SSRS Viewer in a while?
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 are using .NET to refresh the content, which runs into the issue you described in the initial post. To workaround … Continue reading
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 unit test all pass. You need the RRR rule. Legibility (Readability) Code that runs on and one in a single … Continue reading
Posted in Brian's Code Extreme, C#, C-Langs, JavaScript, NO SQL, PL-SQL, SQL, T-SQL
1 Comment
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 posted in Stack Overflow a query that mines every foreign key constraint out of your database for you. However, he … Continue reading
Posted in Brian's Code Extreme, SQL, T-SQL
Tagged Constraints, Foreign Keys, Information_Schema, MSDN, Stack Overflow
Leave a comment
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) as rebuilt datetimeoffset What we started with and want to end with. timezoneoffset What the DatePart extracted from the original … Continue reading
Posted in Brian's Code Extreme, SQL, T-SQL
Tagged DatePart, SwitchOffset, ToDateTimeOffset
Leave a comment
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 Ref. Example: Field Type OrderID Uniqueidentifier FK to the the order table. LineNumber Int The column that we need each … Continue reading
