Back to Browse

How To Reset Identity Column Value in SQL Server Table - SQL Server / TSQL Part 43

13.6K views
May 4, 2016
8:39

SQL Server / TSQL Tutorial Scenario: How To Reset Identity Column Value in SQL Server Table In this video you will learn how to reset identity column. You will learn How to reset identity by using Truncate Table Statement How to use Delete statement to delete data and use DBCC_CheckIdent to reset identity. Link to Scripts used in the video http://www.techbrothersit.com/2014/01/tsql-how-to-reset-identity-column-value.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/

Download

1 formats

Video Formats

360pmp413.5 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

How To Reset Identity Column Value in SQL Server Table - SQL Server / TSQL Part 43 | NatokHD