how to make an existing table field auto-increment in MsSQL

Sep 11 2016 4:43 AM

hi,

I am using Ms SQL 2014.

Please find below the table I have created.

My problem is that I do not know how to make my primary key auto-increment from here.

There isn't a script file for me to load, to my surprise.

Another thing is that I have 2 copies of MS SQL - one is the SQLExpress and the other one is the main one. Not sure why it is so.

Hope someone can advise me on the above. Tks.

Answers (5)

sql server simple query output