SQL Tips

Welcome to the High-Flying SQL Tips.

This area is dedicated to providing some Microsoft SQL Server tips for SQL Server 2000, SQL 2005, SQL 2008 and onwards.

Starting with the most basic of SQL Server commands, from using Select and Where, the collection here will grow to include more advanced techniques on a steady basis.  Check back later for updates.

Add a Unique Constraint to a Column

CURSOR

DELETE

INSERT

Recursive SQL

ROW_NUMBER() - Automatic Paging

SELECT, FROM

SQL Default Date Format

UPDATE

WHERE

To learn how to get started with C#, click here.