Profile
Achievement
You have not received any achievements.rengber's Recent SQL Snippets
- 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
752
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
685
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
641
posted 15 years ago by rengber
Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.
0
725
posted 15 years ago by rengber
This is as small as this can go:
'xs:dateTime(sql:variable("@stringDate"))'
It needs to be a literal string for the Value() function.
Xml Datatype
http://msdn2.microsoft.com/en-us/library/ms189887.aspx
Sql:Variable() Function
http://ms...
0
1103
posted 16 years ago by rengber