create table StudMaster(studid int not null,studname varchar (20) not null

is there more the two primary key in a single table?

Question Posted / vincent

Answer Posted / vincent

create table StudMaster(studid int not null,studname varchar
(20) not null,constraint Studmaster primary key clustered
(studid,studname))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are indexes in ms sql server?

1057

What is acid properties?

1099

Explain time data type in sal server 2008?

923

when would you go for denormalization? : Sql server database administration

870

How to enable tcp/ip protocol on a sql server?

1161

How will you decide the active and passive nodes?

1129

How to get a list of columns in a view using the "sp_columns" stored procedure?

1040

What is the use of group by clause?

942

What is the difference between dropping a database and taking a database offline?

1174

what is denormalization and when would you go for it? : Sql server database administration

1188

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

936

How to download and install microsoft .net framework version 2.0?

1139

How do I find the query plan in sql server?

958

What are the functions in sql server?

947

Tell me what are cursors and when they are useful?

956