Snipplr

(SQL) TSQL Convert DateTime - rengber

Thu, 03 Sep 2009 21:48:26 UTC

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. :-)

(SQL) TSQL to Get the SQL Autonumber ID of the Row Just Inserted - rengber

Mon, 31 Aug 2009 22:48:15 UTC

Dead simple, but often forgotten.

(SQL) SQL Server String Split Function - rengber

Wed, 29 Jul 2009 23:37:26 UTC

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.

(SQL) TSQL Function and Check Constraint to Ensure that a Parent Value is Present in the Table - rengber

Sun, 26 Jul 2009 23:57:39 UTC

If a "InReplyToID" is provided, it must be a valid MessageId

(SQL) TSQL Try Catch Error Handling - rengber

Mon, 23 Feb 2009 21:05:08 UTC

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.

(SQL) TSQL to Start a Job Programatically - rengber

Sun, 22 Feb 2009 15:51:28 UTC

(SQL) Basic TSQL Cursor Syntax - rengber

Wed, 18 Feb 2009 22:21:44 UTC

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

(SQL) TSQL for Recursive Select Using Common Table Expressions - rengber

Mon, 24 Mar 2008 18:00:18 UTC

(SQL) SQL To Show WaitTime and other Process Stats - rengber

Wed, 19 Mar 2008 22:55:37 UTC

(SQL) TSQL to Concatenate Subquery Row Values into a Column Value - rengber

Wed, 19 Mar 2008 22:54:33 UTC

(SQL) TSQL to Reset a Tables Primary Key Autonumber - rengber

Sun, 17 Feb 2008 20:42:49 UTC

(SQL) Add a Constant Value to a RecordSet - rengber

Sun, 20 Jan 2008 19:46:57 UTC

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

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

Wed, 03 Oct 2007 17:51:34 UTC

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://msdn2.microsoft.com/en-us/library/ms188254.aspx 'xs:dateTime( val )' http://www.w3schools.com/xpath/xpath_functions.asp#datetime Xml Datatype Methods http://msdn2.microsoft.com/en-us/library/ms190798.aspx

(SQL) Simple Technique to Subtract Years from an Oracle Date - rengber

Tue, 25 Sep 2007 20:07:30 UTC

(SQL) List all Stored Procedures in an Oracle Database - rengber

Mon, 24 Sep 2007 15:31:54 UTC

(SQL) Using a BitMask in a Where Clause - rengber

Sun, 09 Sep 2007 19:17:07 UTC

(SQL) Update Trigger to Increment a Version Number Column - rengber

Tue, 07 Aug 2007 19:04:22 UTC

(SQL) Search Stored Procedure Code for a String - rengber

Tue, 15 May 2007 21:40:35 UTC

(SQL) Get the Code of a Stored Procedure as Text - rengber

Tue, 15 May 2007 21:39:15 UTC

(SQL) Script to Create a Script Granting EXECUTE to all Stored Procs in a DB - rengber

Sun, 06 May 2007 14:47:51 UTC

(SQL) Oracle DateTime Interval - rengber

Sun, 30 Jul 2006 14:38:35 UTC

(SQL) Oracle Stored Proc to Return a Recordset (Oracle Side) - rengber

Tue, 25 Jul 2006 17:38:46 UTC