Find for SQL Objects, Entities or Text

Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist

CASTing

Finding Available Keys When Merging Two Tables

Find available keys when merging two tables with duplicate keys.

Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.

Returning Data from Stored Proc

Query

Delete Duplicates

Bit data

The "Numbers" or "Tally" Table: What it is and how it replaces a loop

Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.