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

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

Question Posted / jahir

26 Answers
31791 Views
Eforce, Systematix, I also Faced
E-Mail Answers

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 snapshot parameter in ssrs?

140

What is bookmark link in ssrs?

234

How are the exceptions handled in sql server programming?

999

What is subquery explain with example?

1009

What are key, name and value columns of an attribute? : sql server analysis services, ssas

949

What is sqlcmd?

963

What is the difference between Clustered and Non-Clustered Index?

1014

What are built in functions?

954

What do you mean by the term 'normalization'?

1128

What is a ddl statement?

856

Difference between Inner vs outer joins?

895

What is the difference between count () and rowcount ()?

948

What is proper subset of candidate key?

947

What do you mean by cardinality?

848

How many null values we can have in a unique key field in sql server?

905