Disable identity insert in SQL Server

madeinstein , 
SET IDENTITY_INSERT dbo.table_name OFF

INSERT INTO table_name( [Id] , [Name])

SELECT 1 , 'Name1'

SET IDENTITY_INSERT dbo.table_name ON

GO
  
































Comments









  1. Telx Computers29 January 2021 at 06:07
    Very Good information, the information which you have provided is very good and necessary for everyone. Always keep sharing this kind of information. Thank you. IT support Miami
    ReplyDelete











Post a Comment