Forum Discussion
Solved
Identity Insert On Warehouse table
Hi, With data warehouse, I heard IDENTITY_INSERT is now supported on identity columns. When I try to use IDENTITY_INSERT, I still get the "Incorrect syntax near 'IDENTITY_INSERT'." error. CREATE...
Hi deborshi_nag ,
This is when we want to specifically insert data into the Identity column—not always, but when we need to add particular default records to that table. Got some help from Microsoft, and it looks like that feature will be available within the next two weeks.
Hello PraveenVeli
You don't need SET IDENTITY INSERT ON/OFF statements. Just ignore the identity column in your INSERT statement.
INSERT INTO [dbo].[Test]
([Name])
VALUES ('Test1');
Hi deborshi_nag ,
This is when we want to specifically insert data into the Identity column—not always, but when we need to add particular default records to that table. Got some help from Microsoft, and it looks like that feature will be available within the next two weeks.