Interested to Buy Any Domain ? << Click Here >> for more details...
is there more the two primary key in a single table?
- 26 Answers
- 31743 Views
- Eforce, Systematix, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
No, When creating table using script we can create primary
key another one is called composite key that means
combination of more than
one column...
CREATE TABLE [LoginHist] (
[LogDate] [smalldatetime] NOT NULL ,
[ClientIp] [char] (15) NOT NULL ,
[LoginCount] [int] NULL DEFAULT (0),
CONSTRAINT [PK_LoginHist] PRIMARY KEY CLUSTERED
(
[LogDate],
[ClientIp]
) ON [PRIMARY]
) ON [PRIMARY]
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is SQL Azure?
How to list all stored procedures in the current database using ms sql server?
Are resultset updatable?
How to disconnect from a sql server using mssql_close()?
What is user defined datatypes and when you should go for them?
Describe the functionalities that views support.
Explain how many normalization forms?
Why do we partition data?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What are exact numeric data types in ms sql server?
Do you know how to implement service broker?
What is difference between views and tables?
Tell me can we use custom code in ssrs?
How to count duplicated values in a column in ms sql server?
