syntax error table variable

Question

This is the code:

declare @Ids table ( Id int identity(1,1));

SET IDENTITY_INSERT @Ids ON;

and I get:

Incorrect syntax near '@Ids'

I cannot see what's wrong. Any ideas? Thanks.

gbn · Accepted Answer · 2012-02-06 10:02:00Z

8

You can't use SET IDENTITY_INSERT on table variables

This works

CREATE TABLE Ids ( Id int identity(1,1))
SET IDENTITY_INSERT Ids ON

and this

CREATE TABLE #Ids ( Id int identity(1,1))
SET IDENTITY_INSERT #Ids ON

answered Feb 6, 2012 at 10:02

gbn

435k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment