Function Based Index in T-SQL

To build function based index in SQL Server, you can use indexed view (materialized view) or using a computed column. In this script, I give an exmaple of how to use the computed column to implement a function based index on a table to search through a free formated telephone number column. The basic step […]

Query Hierarchical data Using CTE in T-SQL 2005

In response to Sam Stange's "An old and new way to query Hierarchical data", this script uses the new CTE feature of SQL Server 2005 to display the hierarchical data all at once. I have added a check to prevent infinite loop in case there is a loop in the data (actually, there is one […]

What does CONTINUE do in T-SQL?

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. […]