SQL 创建联合主键Table

CREATE TABLE [User_Instance](
    [IntanceID] [int] NOT NULL,
    [StaffID] [char](10) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


ALTER TABLE [[User_Instance] WITH NOCHECK ADD 
    CONSTRAINT [PK_User_Instance] PRIMARY KEY  NONCLUSTERED 
     (
          IntanceID,
          StaffID
     )