In the primary key have a multiple field or not?
Answers were Sorted based on User's Feedback
Answer / prashanth kumar
Yes , it have multiple fields.Run below query and creating
primary key on p_Id and LastName.
CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / rajkumar
s primary key have the multiple filed use os composite
primary key.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ziyaur rahman
no,in one table there is only one primary key field
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / prasadhari_m@yahoo.com
A TABLE ALLOWS ONLY ONE PRIMARY KEY.
Is This Answer Correct ? | 0 Yes | 1 No |
Explain the steps to use transact-sql cursor?
What is ssl in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
A left outer join B B right outer join A gives the same result then what is the use of two?
Where in ms sql server is ’100’ equal to ‘0’?
What are the source of constraints?
What is difference between clustered index and non clustered index?
What is data modeling and Reterminal integrity?
Explain what is log shipping?
How do you delete duplicate records in sql server?
Define magic tables in sql server?
What are the differences between triggers and stored procedures?