i trying write create table stored proc in t-sql. table should have pk, want pk automatically seed integer values beginning 1. here code have getting error when try add records. how should define table instead?
use identity(1,1)
, i.e.
create table mytable ( myfield bigint identity(1,1) primary key, ... ... )
Comments
Post a Comment