- 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
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
Category Archives: T-SQL
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
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
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
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