delete from Table_Name
DBCC CHECKIDENT (Table_Name, RESEED, 0)
Embracing externalities
16 hours ago
This is my 'technical stuff' blog on all things ASP.NET, SharePoint and C#.
...Sydney IT Consultant - Paul Rowland...
delete from Table_Name
DBCC CHECKIDENT (Table_Name, RESEED, 0)
SELECT Column_Name + ', '
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Table_Name'