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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

your distribution database is full what will u do

1672


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

689


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1712


How can i Relate Tables in SSIS

566


Show Practically Sql Server Views are updatable?

578






How do you debug a procedure in sql server?

486


What are the components of sql server service broker?

498


what is difference between NULL and ISNULL in SQL Server 2008?

569


What is bit data type? What's the information that can be stored inside a bit column?

508


How can we check the sql server version?

544


Do you know hot add cpu in sql server 2008?

526


What is the purpose of object explorer and its features? : sql server management studio

588


What is meant by Active-Passive and Active-Active clustering setup?

543


What is the difference between createstatement and preparedstatement?

477


What is report snapshot?

99