tsql - How do I write a T-SQL stored proc to create primary key? -


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