Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2014-10-20 : 05:30:23
|
| Hi All,I have a query here.Why it behaves different for IDENTITY property in DELETE and TRUNCATE.i.e. when we delete it continues to insert from the last inserted value but for TRUNCATE it re initiate to the seed.can some one please explain why this is the behaviour.TIA |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-20 : 08:59:06
|
| That's the way it works in SQL SERVER. See http://msdn.microsoft.com/en-us/library/ms177570.aspx |
 |
|
|
|
|
|
Difference in DELETE and TRUNCATE for IDENTITY