Sql

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

/*If you have delete all the rows in a table, and you want to reset the identity column value, use this*/
DBCC CHECKIDENT ('Table_Name',RESEED,0)

DBCC CHECKIDENT ('Table_Name',RESEED,0)

USE <databasename>;  
GO  
DBCC CHECKIDENT ('<tablename>.<columnname>', <value>, <incrementby>);  
GO

PREVIOUS	NEXT

Code Example
Sql :: Use Join On DataTables \| Join Two Tables With ssp.class.php (Select & Search)
Sql :: geopoint from json mysql function
Sql :: utiliser sql ligne de commande
Sql :: insert thai language sql server
Sql :: sql alchemy escape ; in insert statement
Sql :: oracle user used size
Sql :: sql filter rows with condition
Sql :: ejecutar script sql
Sql :: psql
Sql :: Invoke-Sqlcmd : Execution Timeout Expired
Sql :: mysql drop table
Sql :: sqlx many to many join
Sql :: sql to mongodb query converter
Sql :: full outer join in sql
Sql :: distance calculator from lat long sql query
Sql :: convert sql query to laravel eloquent
Sql :: sequelize with mysql nodejs
Sql :: row over partition in sql
Sql :: select all users sql
Sql :: example of sql querry result sepapreted by comma
Csharp :: lockstate untiy
Csharp :: unity how to convert mouse screen position to world position
Csharp :: unity how to get y value
Csharp :: c sharp split by newline
Csharp :: how to call something once in update
Csharp :: unity check for internet connection
Csharp :: stop program event in unity code
Csharp :: how to change a image with code unity
Csharp :: c# get current date
Csharp :: c# cast string to double