In the primary key have a multiple field or not?
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 are types of storage modes? : sql server analysis services, ssas
List all the types of user-defined functions?
What is tabulation?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What are commonly used odbc functions in php?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How many types of the database links?
Does any body please help me what question's have asked for SSRS in the interview?
How can I check that whether automatic statistic update is enabled or not?
Explain the truncate command? : SQL Server Architecture
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Explain about link server in sql server?
What are distributed partitioned views?
Why do we backup Active Directory ?
Can we call stored procedure in trigger?