rengber

Member since 07/25/2006

Location: New Zealand

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

21 snippets

16942 profile views

2 Comment(s) Posted

View their favorites

their Tags

Oracle sql script security database xml data query simple

Profile

Achievement

You have not received any achievements.

rengber's Recent SQL Snippets

All /

« Prev 1 Next »

SQL TSQL Convert DateTime

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 2167 posted 16 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

1 1876 posted 16 years ago by rengber

SQL SQL Server String Split Function

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 1741 posted 16 years ago by rengber

SQL TSQL Try Catch Error Handling

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.

database

0 1694 posted 17 years ago by rengber

SQL TSQL to Start a Job Programatically

database

0 1634 posted 17 years ago by rengber

SQL Basic TSQL Cursor Syntax

Minimal syntax for cursor use. See URL for SQL 2005 options and improvements.

database

0 1753 posted 17 years ago by rengber

SQL TSQL for Recursive Select Using Common Table Expressions

0 1740 posted 18 years ago by rengber

SQL SQL To Show WaitTime and other Process Stats

0 1605 posted 18 years ago by rengber

SQL TSQL to Concatenate Subquery Row Values into a Column Value

0 1927 posted 18 years ago by rengber

SQL TSQL to Reset a Tables Primary Key Autonumber

database
sql

0 1586 posted 18 years ago by rengber

SQL Add a Constant Value to a RecordSet

Noob stuff, but I always end up looking this up.

0 1513 posted 18 years ago by rengber

SQL TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

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 2252 posted 18 years ago by rengber

SQL Simple Technique to Subtract Years from an Oracle Date