提问一个建表问题？？？

[xronguo]

我建一个表有1，2，3，4。我想让1，2做主键（两者完全一致才确定一条记录）。请问SQL语句怎样写。

[lxf_1976]

CREATE TABLE tbl_name
(
1 int,
2 char(3),
3 float,
4 varchar(32),
primary key (1, 2)
);

[SilverSands]

// 创建表
CREATE TABLE [dbo].[cw_sy_qxsz] (
[zth] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[username] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[xtname] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[qx] [int] NULL
) ON [PRIMARY]
GO

// 创建主键
ALTER TABLE [dbo].[cw_sy_qxsz] WITH NOCHECK ADD
CONSTRAINT [PK_cw_sy_qxsz] PRIMARY KEY CLUSTERED
(
[zth],
[name],
[username],
[xtname]
) ON [PRIMARY]
GO

[heavenmusic]

可以设置,,两个主键吗??