Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.

Variables, Nulls and Coalesce

ISNUMERIC() and REPLICATE()

^ : T-SQL

Cast as datetime question

T-SQL

REPLACE Multiple Spaces with One

Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method from MVP Jeff Moden.

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.

syscolumns names

get a list of syscolumns names from string comma separated columns list

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.