SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
pitfalls
.
Show all posts
Showing posts with label
pitfalls
.
Show all posts
Monday, December 17, 2007
Use XACT_STATE() To Check For Doomed Transactions
›
Let's say you have the following transaction BEGIN TRANSACTION TranA BEGIN TRY DECLARE @cond INT ; SET @cond = 1 END TRY BEGIN CATCH P...
Thursday, December 13, 2007
The Strange Case OF Nulls And Case
›
Okay it is not Dr. Jekyll and Mr. Hyde but I had to come up with a title. This was a question someone asked yesterday in the sql programming...
2 comments:
›
Home
View web version