Campare Case Insensitive  CampareCaseInsensitive

Case Insensitive Camparison remains a problem for most developers since SQL Server not supports any built in function for these purpose here is one wich compares varchar strings and returns 1 is mathes and 0 other wiseselect dbo.CampareCaseInsensitive('A','a')

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?