Category: sql server

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 procedure util.ViewJobHistory( @ExecutionDate date = null ,@JobName sysname = null)asbegin declare […]

Assuming you have a table type named SingleColumnText which contains (obviously) a […]