From dePoPo.net

SQL Quick Reference

Posted in: SQL

By dePoPo
May 12, 2009 - 2:03:07 PM

INSERT INTO

INSERT INTO table (col1, col2, col3) VALUES (val1, val2, val3)
INSERT INTO table VALUES (val1, val2, val3)

SELECT DISTINCT

SELECT DISTINCT col1 FROM table

SUM function

SELECT SUM(expression) as "Expr1" FROM tablename WHERE conditions;

Reseeding an identity column in an empty table

dbcc checkident (tablename,RESEED,0)

© Copyright 2010 by dePoPo.net