添加主键

--Add Key

alter table [dbo].[BF2ZFB02]

add IDKeyGUID  uniqueidentifier

--Set Key Value

update [BF2ZFB02] set IDKeyGUID =  newid()

--Alter Key Not Null

alter table [dbo].[BF2ZFB02]

alter column   IDKeyGUID  uniqueidentifier not null

--Alter Key as Primary Key

ALTER TABLE [BF2ZFB02]

ADD CONSTRAINT PK_IDKeyGUID PRIMARY KEY (IDKeyGUID)

添加主键

原文：http://www.cnblogs.com/ifreesoft/p/4955441.html