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

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -