Interested to Buy Any Domain ? << Click Here >> for more details...
In the primary key have a multiple field or not?
- 8 Answers
- 9125 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
Is mysql better than sql server?
What is apply operator in sql?
What are the differences between stored procedure and the dynamic sql?
How can we get count of the number of records in a table?
What is a partition function in sql server?
What is implicit mode in sql server?
How do indexes help, types?
How to list all user names in a database?
Can we insert data into a view?
Does a full backup include transaction log?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
how you can move data or databases between servers and databases in sql server? : Sql server administration
what are triggers? : Sql server database administration
Tell me can we use custom code in ssrs?
What do you understand by physical_only option in dbcc checkdb?
