复合主键的问题
Create table #temp(
No int primary key ,
Name char(10)
)

现在想让No和Name 都为主键怎么写?

[解决办法]
CONSTRAINT PK_emp_id PRIMARY KEY(no,name)


[解决办法]
CREATE TABLE #temp(
No int ,
Name char(10) ,
CONSTRAINT [PK_Temp] PRIMARY KEY CLUSTERED (No,name)
)


[解决办法]
Create table temp(
No int ,
Name char(10)
constraint pk_idname PRIMARY KEY([no],[name]))
[解决办法]
楼主在联机帮助里，很详细和例子：
打开联机帮助—输入—create table

[解决办法]
CREATE TABLE [表名] (
[F1] [int] NOT NULL ,
[F2] [int] NOT NULL ,
[num] [int] NULL ,
CONSTRAINT [PK_表名] PRIMARY KEY CLUSTERED
(
[F1],
[F2]
) ON [PRIMARY]
) ON [PRIMARY]
GO



[解决办法]
Create table temp(
No int ,
Name char(10)
constraint pk_idname PRIMARY KEY([no],[name]))