Understanding IDENTITY_INSERT in SQL Server Many of us will get a basic question on whether the IDENTITY_INSERT is ON or OFF on a SQL Table. We also have some confusion between IDENTITY and IDENTITY_INSERT. In this article i will explain the basic use of IDENTITY_INSERT and how it exactly works. Before understanding the IDENTITY_INSERT we need to know what is an identity column. It is column which keeps on incrementing without supplying the value explicitly during insertion. In the below table EID is an identity column which will be incremented by 1 when a...
Microsoft Blog undefined
DotNet and SQL Articles, Troubleshooting guides, ebooks, Frequently used stuff.
Copyrights @ 2013, BrandMag Blogger Template - Designed By Templateism | MyBloggerLab