DELETE FROM dbo.TABLENAME WHERE id > 500
DECLARE @MAX INT;
SELECT @MAX = MAX(ID) FROM TABLENAME AS NCPD;
dbcc checkident(TABLENAME,reseed,@max)
DECLARE @MAX INT;
SELECT @MAX = MAX(ID) FROM TABLENAME AS NCPD;
dbcc checkident(TABLENAME,reseed,@max)
No comments:
Post a Comment