/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 vote253 views1 answer
Find invalid datetime field
SQL
3 votes242 views2 answers
Mysql add 2 hours
SQL
0 vote261 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote273 views1 answer
Alter boolean column postgresql
SQL
0 vote261 views1 answer
Connecting mySQL to STS
SQL
0 vote287 views1 answer
Dynamic where clause in sql server stored procedure
SQL
3 votes242 views1 answer
Mysql set field unique
SQL
0 vote266 views2 answers
Sql query inner join 3 tables
SQL
0 vote273 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote247 views1 answer
Sql query for getting data with join and count
SQL