* Copy a Table

SELECT * INTO NewTable FROM OldTable;


* Specifying an Identity Field in an Insert

SET IDENTITY_INSERT MyTable ON;
INSERT INTO MyTable (id, name) VALUES (1, 'Hi');
SET IDENTITY_INSERT MyTable OFF;


* Reseed and Identity Column

DBCC CHECKIDENT('MyTable', RESEED, 69);