sql server - insert issues in an auto increment column -
how can insert data column has been defined auto increment column using identity insert?please explain example.
if have "auto-increment" column - shouldn't inserted specific values column - after all, that's why it's auto-increment column....
if must after - need do:
set identity_insert (your table name here) on insert (your table name here) (identitycol, othercol1, .....) values( (new id value), .......) set identity_insert (your table name here) off
Comments
Post a Comment