/SQL/Reset a table's identity column and remove test records

Reset a table's identity column and remove test records

-- Delete Record From table
DELETE FROM tbl_emp
WHERE id >= 4 ;

DECLARE @NewSeed NUMERIC(10)

-- Get the Last Value from the Table from where
-- You want to restore the Identity Column Value
SELECT @NewSeed = MAX(id)
FROM tbl_emp ;

-- RESEED the IDENTITY column Value
DBCC CHECKIDENT (tbl_emp, RESEED, @NewSeed)

Source: tutorialsrack.com

Similar codes

0 vote115 views1 answer
Codigo crear tablas sql server
SQL
1 vote95 views1 answer
Oracle check table space
SQL
0 vote59 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
46 votes171 views4 answers
Create column sql
SQL
2 votes108 views1 answer
Date conversion in mysql column
SQL
0 vote57 views1 answer
Mysql convert column to uppercase
SQL
3 votes99 views2 answers
Sql paging query
SQL
0 vote111 views1 answer
Mysql update even / odd rows
SQL
4 votes102 views2 answers
Select first and last row mysql
SQL
0 vote98 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL