Snipplr - rengber

(SQL) TSQL for Recursive Select Using Common Table Expressions

Mon, 24 Mar 2008 18:00:18 GMT

(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) 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