SET IDENTITY_INSERT on an in-memory table?
I'm 98% sure this can be done, but I'm not finding anything on the web that explicitly says yes or no, and I want to rule out the possibility that I'm just banging my head against a wall. T-SQL, SQL Server 2005.
Can SET IDENTITY_INSERT be used on an in-memory table? e.g.,
DECLARE @m_tblOpenReceipts TABLE (
ID INT IDENTITY (1,1), (etc.)
}
...
SET IDENTITY_INSERT @m_tblOpenReceipts ON
Thanks.
Can SET IDENTITY_INSERT be used on an in-memory table? e.g.,
DECLARE @m_tblOpenReceipts TABLE (
ID INT IDENTITY (1,1), (etc.)
}
...
SET IDENTITY_INSERT @m_tblOpenReceipts ON
Thanks.
