rengber


Member since 07/25/2006

Location: New Zealand

Website: http://rengberg.blogspot.com/

21 snippets

4552 profile views

2 Comment(s) Posted

View their favorites

Profile

Achievement

You have not received any achievements.

rengber's Recent SQL Snippets



« 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 763 posted 14 years ago by rengber
Dead simple, but often forgotten.
1 708 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 692 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 644 posted 15 years ago by rengber
Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.
0 735 posted 15 years ago by rengber
Noob stuff, but I always end up looking this up.
0 592 posted 16 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 1108 posted 16 years ago by rengber
0 537 posted 16 years ago by rengber
0 524 posted 17 years ago by rengber
« Prev 1 Next »