Search This Blog

Friday, January 28, 2011

Inserting Specific Identity Values

SET
  #a (i,j)
INSERT
SELECT 2,2
 
SET
  * FROM #a
SELECT
IDENTITY_INSERT #a OFF
IDENTITY_INSERT #a ON

No comments:

Post a Comment