SET IDENTITY_INSERT dbo.MyTable ON;
INSERT INTO dbo.MyTable
SET IDENTITY_INSERT dbo.MyTable OFF;
Do you have any idea how can i convert a existing integer column to identity.
Say for e.g. i have a "ID" column which is int, later on i want to change it to identity.
How can i do that?
Managed Windows Shared Hosting by OrcsWeb