Profile
Achievement
You have not received any achievements.rengber's Recent SQL SnippetsTagged database
- All /
« Prev 1 Next »
I am forever forgetting this. Have to look up the 101 vs 103 in books online every time.
Also forget which way around is US/NZ format. :-)
1
776
posted 14 years ago by rengber
From StackOverflow. I'm still not quite happy with my understanding of it, but it looks an order of magnitude more elegant than most I've found.
0
710
posted 14 years ago by rengber
This as it sits isn't an improvement on what happens by default. It's only useful combined with a compensating transaction or sad path in the catch block, or in allowing a loop to continue.
0
655
posted 15 years ago by rengber
Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.
0
748
posted 15 years ago by rengber