Interested to Buy Any Domain ? << Click Here >> for more details...
In the primary key have a multiple field or not?
- 8 Answers
- 9207 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between createstatement and preparedstatement?
How check triggers in sql server?
Can I work with several databases simultaneously? : sql server management studio
Why it is recommended to avoid referencing a floating point column in the where clause?
What is snapshot report?
Introduction of rollup clause using sum and group by clause?
What is use of @@ spid in sql server?
How to use clusters?
Is it ok to shrink transaction log?
How can you insert null values in a column while inserting the data?
What are dml triggers and types of dml triggers?
What according to you is the difference between mysql and sql server performance?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is the maximum size of sql server database?
ow to bring suspect mode datbase online from scratch
