When you’re working through a cursor, if you need to update each record one at a time, here’s a simple example: if object_id(‘tempdb..#joe’) is not […]

To make a column case-sensitive instead of the default case-insensitive, just add a COLLATE to the column definition, and it’ll use that instead of the […]

Sometimes you just need to disable all constraints on a database. Maybe you’re doing some massive data inserts or updates, and the constraints slow it […]

Need a globally unique key for a table, but don’t want to risk performance issues arising from a random clustered index? And you don’t want […]

create function dbo.ConvertFromBase64String (@Base64Value varchar(max))returns varbinary(max)asbegin return cast(” as xml).value(‘xs:base64Binary(sql:variable(“@Base64Value”))’, ‘varbinary(max)’);end;gocreate function dbo.ConvertToBase64String (@BinaryValue varbinary(max))returns varchar(max)asbegin return cast(” as xml).value(‘xs:base64Binary(sql:variable(“@BinaryValue”))’,’varchar(max)’);end;godeclare @b varbinary(max) = cast(‘hello’ as […]

create procedure util.ViewJobHistory( @ExecutionDate date = null ,@JobName sysname = null)asbegin declare @executionDateInt int; set @executionDateInt = year(@ExecutionDate) * 10000 + month(@ExecutionDate) * 100 + […]

Assuming you have a table type named SingleColumnText which contains (obviously) a single column of text, named [TextValue]: create function util.Flatten( @input util.SingleColumnText readonly ,@delimiter […]

If you have a large string, possibly with line breaks, it may be difficult to read this in SSMS – there are ways to do […]

Here are my favorite date formats in SQL Server. These work with older versions, in case you’re not able to use the new format feature: […]