Faking Multidimensional Arrays in T-SQL made easy!

Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!

Text Data

Compare Dates

The following article shows how to compare dates in an iterative manner for a particular set of records in a single query

Introduction to New T-SQL Programmability Features in SQL Server 2008

This paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements.

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?

Audit data using SQL Server 2005's COLUMNS_UPDATED function

Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.

SQL Server Cursor Examples

In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?

SQL Script To Find For A Particular Column In A Database

This small script help u to find the column exists in the list of tables in a database.

Predict output

SUM of FLOAT inconsistency