Hi there, I want to add/create 300 rows in a able with an idendity column. I want to give specify the values for the identity column, e.g. I want to insert 300 rows with identity number 55 to 355
I can do this,
SET IDENTITY_INSERT [MYTABLE] ON INSERT INTO MYTABLE (id, creator) values 55, 'Autoprocess' SET IDENTITY_INSERT [MYTABLE] OFF
however, I would need to do this 300 times. Is there a way to insert all 55 to 355 in one query?