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

Answer Posted / jahir

refer below, actually its not primary key, Its Composite Key

CREATE TABLE [LoginHist] (
[UserId] [char] (15) NOT NULL ,
[LogDate] [smalldatetime] NOT NULL ,
[ClientIp] [char] (15) NOT NULL ,
[LoginCount] [int] NULL DEFAULT (0),
CONSTRAINT [PK_LoginHist] PRIMARY KEY CLUSTERED
(
[UserId],
[LogDate],
[ClientIp]
) ON [PRIMARY]
) ON [PRIMARY]

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between functions and stored procedures?

594


How many types of subqueries are there in sql server?

441


What is function of CUBE ?

586


What is spid in sql server profiler?

502


What will be query used to get the list of triggers in a database?

522






What is dknf in normalization form?

539


Explain logical operators in sql server?

553


How do I view a stored procedure in sql server?

499


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

564


What are the methods used to protect against sql injection attack?

533


Do you know what is xpath?

535


What are transactions in sql?

526


How to execute stored procedure in select statement sql server?

511


What are different backups available in sql server?

577


Write down the syntax and an example for create, rename and delete index?

511