Code Comparison between two databases

This script compares the code (SP, Func. etc.) between two databases (say Dev and QA) and reports the objects which have differences.

What does the NULLIF function do?

Fetching Ordinal number text

Interested in getting the ordinal number as text?You know, 1st, 32nd and so on?Have a look at this script.peso@developerworkshop.net

What does this WHERE clause evaluate to? (there...

Match Date Only

Here is a simple function to compare datepart of datetime fields , (no need to say ignores hour t,min,sec ... ) isDateMatch(@date1,@date2 ) retruns 1 if the datepart matches else returns 0regardsjohn

AUDIT WITH A TWIST

First the SP_TABLECOMPARE was used from the site and all credit must go to the author (greate script). This script is for the creation of an audit trial. It is generic and can be used on any sql database. It deals with legasy naming conventions as well. The script creates the audit tables and triggers. […]

What does a return value of -1 mean...

Improved Split function

This is a script function I've been using for years.

What does VARP() do in SQL Server 2005?

Script SQL Server DDL

Scripting SQL Server DDLRichard SutherlandIf you buy into the theory that all database objects should be contained in a source management system such as Visual SourceSafe, and that deployment of database projects should be done from the source management system, then the manner in which Microsoft's Visual Studio 2005 Team Edition for Database Professionals [a.k.a., […]