Back to Browse

How to reset identity to 1 in SQL server | Difference b/w Truncate and Delete | Database Sql server

4.9K views
Mar 24, 2019
10:55

Microsoft SQL Server's identity column generates sequential values for new records using a seed value. The term seed refers to the internal value SQL Server uses to generate the next value in the sequence. By default, an identity column's first value is 1 and each new value increments by one (1, 2, 3, 4, and so on). For more video please like ,share and subscribe to my channel. facebook :https://www.facebook.com/learnfromsalmanmasood/?ref=bookmarks youtube : https://www.youtube.com/channel/UCHAmv9m1l_BqbiPFvwWv1aw instagram : https://www.instagram.com/salmanmasood_ideas/

Download

1 formats

Video Formats

360pmp414.4 MB

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

How to reset identity to 1 in SQL server | Difference b/w Truncate and Delete | Database Sql server | NatokHD