delete from Table_Name
DBCC CHECKIDENT (Table_Name, RESEED, 0)
Monday, 31 March 2008
SQL Snippet - Reseed Identity Column to Zero
Reseed Identity Column to Zero
Sql Snippet - Get Table Column Names In A Query
Get Table Column Names In A Query
SELECT Column_Name + ', '
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Table_Name'
Wednesday, 19 March 2008
Subscribe to:
Comments (Atom)