is there more the two primary key in a single table?
- 26 Answers
- 28656 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
Explain what is lock escalation?
What is the difference between varchar and nvarchar?
What is the native system stored procedure to execute a command against all databases?
whats new about truncate in sql server 2008?
Does transparent data encryption provide encryption when transmitting data across the network?
Mention the command used to rename the database.
How many cores do I need for sql server 2016?
Do you know data definition language, data control language and data manipulation language?
What Is Rdbms?
How can you tell if a database object is invalid?
What are different types of database indexes?
How you would rewrite the sql query to return the customerid sorted numerically?
What is the purpose of the tempdb database?
Does windows server 2016 come with sql server?
What is public role in sql server?
