Tag: sql server

 If you’re working locally, building a new app from scratch, you might […]

Here’s my preferred syntax for a simple one-way readonly cursor: It uses […]

When you’re working through a cursor, if you need to update each […]

To make a column case-sensitive instead of the default case-insensitive, just add […]

Sometimes you just need to disable all constraints on a database. Maybe […]

Need a globally unique key for a table, but don’t want to […]

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 […]

create procedure util.ViewJobHistory( @ExecutionDate date = null ,@JobName sysname = null)asbegin declare […]