SQL Quick Reference

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

Digg this story!
Email this article
Printer friendly page

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)

Visitor Comments

Leave a comment