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
What is the difference between functions and stored procedures?
How many types of subqueries are there in sql server?
What is function of CUBE ?
What is spid in sql server profiler?
What will be query used to get the list of triggers in a database?
What is dknf in normalization form?
Explain logical operators in sql server?
How do I view a stored procedure in sql server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What are the methods used to protect against sql injection attack?
Do you know what is xpath?
What are transactions in sql?
How to execute stored procedure in select statement sql server?
What are different backups available in sql server?
Write down the syntax and an example for create, rename and delete index?