Monday, March 12, 2012

Identity Insert

How do I turn on IDENTITY_INSERT for a table in SQL 2005?
Regards,
Fred Chateau
fchateauAtComcastDotNetSET IDENTITY_INSERT yourschema.yourtable ON
GO
eg
SET IDENTITY_INSERT dbo.Customers ON
GO
HTH,
Paul Ibison
(btw BOL has all of this in good detail).

No comments:

Post a Comment