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:

sql server add auto increment primary key existing table


Comments

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

transpose - Maple isnt executing function but prints function term -