SQL Server: How to set two Primary Key in same table.

要對Sql Server 更改 table 為兩個primary key，使用以下 SQL Command

ALTER TABLE Table1
ADD CONSTRAINT pk_PersonID PRIMARY KEY (AgentId, IdIndicator)

Reference:

http://stackoverflow.com/questions/12167689/change-primary-key-to-composite-key-primary-key-already-exists