search

PeterHenell / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer
0 stars 1 forks source link

IDENTITY columns should be possible to insert using identity_insert on #67

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
If i have a table with an identity column i want to be able to select my own 
identity values using SET IDENTITY_INSERT tableName ON.

It should then be possible to use the regular integer generators for that 
column.

Original issue reported on code.google.com by a03pe...@gmail.com on 21 Oct 2012 at 10:07

GoogleCodeExporter commented 9 years ago 
Required for Milestone 1 (Release 1)

Original comment by a03pe...@gmail.com on 31 Oct 2012 at 1:40

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 26 Nov 2012 at 2:32

GoogleCodeExporter commented 9 years ago 
Create a generator that says SQL Server Identity
Make that generator available if the column is identity
If that generator is used then just use the value inserted by identity.

if any other generator is used then set identity_insert on for that table 
during the insertion and use the provided regular generator to generate the 
value for the column.

Original comment by a03pe...@gmail.com on 4 Dec 2012 at 10:35

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 6 Dec 2012 at 2:08