sql server - Insert without specifying RowID -
i'm trying insert values table , getting error message,
cannot insert value null column "rowid". do have find last rowid value in table , manually input every time insert insert below?
insert table1 (rowid, name, gender) values (801, john, male) is there way insert like:
insert table1 (rowid, name, gender) values (autoinputrowid, john, male)
assuming rowid column auto increment column, can omit insert in order sql server automatically assign value it:
insert table1 (name, gender) values ('john', 'male') if rowid not auto increment column , need such functionality, might have bit of work do, q.v. here:
Comments
Post a Comment