SQL Tips


SQL Tips

Add a Unique Constraint to a Column

CURSOR

DELETE

INSERT

Dirty Reads and Phantom Reads

Recursive SQL

ROW_NUMBER() - Automatic Paging

SELECT, FROM

SQL Default Date Format

UPDATE

WHERE

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.



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