Answers for "to add a primary key to alter table in sqlserver"

add primary key to existing table sql

alter table Persion add primary key (persionId,Pname,PMID)

sql server add primary key to existing table with data

ALTER TABLE Production.TransactionHistoryArchive
   ADD CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (TransactionID);