tag:blogger.com,1999:blog-9075786158122089104.post1889740252695273539..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: SET IDENTITY INSERT – how to insert value in IDENTITY Column in Microsoft SQL ServerRitesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-9075786158122089104.post-78346260340144670582011-08-01T16:40:39.397+05:302011-08-01T16:40:39.397+05:30BTW, there is one more interesting fact about inse...BTW, there is one more interesting fact about inserting values in IDENTITY column.<br /><br />create table SQLHub<br />(<br />id int identity(1,1)<br />)<br />GO<br /><br />insert into sqlhub default values<br />GO<br /><br />select * from SQLHub<br />goRitesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.com