enquires@blushmedia.co.uk

Home
Services and prices
Portfolio
Contact Us

SET IDENTITY_INSERT

Menu

CASE
Generating GUID
IF ELSE END
ISNULL
Last Inserted ID
Memory tables
Memory tables with JOIN
Select tables from database
SET IDENTITY_INSERT [table_name] ON
TRANSACTIONS
Variable

How to turn off auto identity on primary key

SET IDENTITY_INSERT [User] ON
-- INSERT STAEMENTS HERE
SET IDENTITY_INSERT [User] OFF

Copyright 2012. All rights reserved.