SQLServerCentral.com Scripts tagged data

Search for String in all columns

Wed, 07 Nov 2012 07:00:00 UT

Find all columns containing a string value across all tables and schemas.

Generate MERGE statements with Table data

Mon, 08 Oct 2012 06:00:00 UT

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.

Function to Add Leading 0's (Zeros) to an INT

Thu, 05 Mar 2009 07:00:00 UT

Very simple function code to add leading zeros to a passed in int for a length also passed.