unique column in table

Question

HI,

merging table1 in table2

merge into table2 using table1 on table.col1=table2.col1

when not match then insert

how to add unique column with auto increament number and not null in table like

uniquenumner; Name;'

001 Test1

003 Testg2

Answer 1

Hi @Vineet S

how to add unique column with auto increament number and not null in table

Add a new column ID that is unique and auto-incrementing:

ALTER TABLE YourTable ADD ID INT IDENTITY(1,1) PRIMARY KEY;

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".