Re-Identity a Table in SQL Server

0Comments

TODO: Have you ever wanted to re-indentity a column in SQL Server?

SOLUTION:

T-SQL

DECLARE @Count INT
SET @Count = 0

UPDATE [dbname].[dbo].[table]
SET  @Count = [id] = @Count+1

NOTES:

Identity Insert must be enabled.

"Id" is the name of the identity column.

How To Pass A DataTable To A Stored Procedure Using C# and SQL ServerTODO: Have you ever wanted to pass a DataTable from your C# application to a Stored Procedure in SQ...How to Find And Rebuild Fragmented Indexes In SQL Server Using T-SQLTODO: Have you ever wanted to get badly fragmented indexes, and rebuild them using T-SQL? ...How To Create A Table From a Select Statement Using T-Sql In SQL ServerTODO: Have you ever wanted to create a table from a SELECT statement in SQL Server? SOLUTI...

	Subscribe		Contact
Archive		Twitter

Thank you