Snipplr - rengber

(SQL) TSQL for Recursive Select Using Common Table Expressions

Mon, 24 Mar 2008 18:00:18 GMT

(SQL) SQL To Show WaitTime and other Process Stats

Wed, 19 Mar 2008 22:55:37 GMT

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

Wed, 19 Mar 2008 22:54:33 GMT

(SQL) TSQL to Reset a Tables Primary Key Autonumber

Sun, 17 Feb 2008 20:42:49 GMT

(SQL) Add a Constant Value to a RecordSet

Sun, 20 Jan 2008 19:46:57 GMT

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

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

Wed, 03 Oct 2007 17:51:34 GMT

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

Tue, 25 Sep 2007 20:07:30 GMT

(SQL) List all Stored Procedures in an Oracle Database

Mon, 24 Sep 2007 15:31:54 GMT

(SQL) Using a BitMask in a Where Clause

Sun, 09 Sep 2007 19:17:07 GMT

(SQL) Update Trigger to Increment a Version Number Column

Tue, 07 Aug 2007 19:04:22 GMT

(SQL) Search Stored Procedure Code for a String

Tue, 15 May 2007 21:40:35 GMT

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

Tue, 15 May 2007 21:39:15 GMT

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

Sun, 06 May 2007 14:47:51 GMT

(SQL) Oracle DateTime Interval

Sun, 30 Jul 2006 14:38:35 GMT

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

Tue, 25 Jul 2006 17:38:46 GMT