Interested to Buy Any Domain ? << Click Here >> for more details...
is there more the two primary key in a single table?
- 26 Answers
- 32633 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
How to apply filtering criteria at group level with the having clause in ms sql server?
What is rank function?
What are secondary xml indexes?
How to download microsoft sql server 2005 express edition?
how you can get the list of largest tables in a database? : Sql server administration
How to find index size for each index on table?
Where can you find the error log information? : sql server database administration
Explain mixed authentication mode of sql server?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain following error properties?
What happens if date-only values are provided as date and time literals?
can SSRS reports Cache results?
Does order by actually change the order of the data in the tables or does it just change the output?
Explain intellisense for query editing
Do you know what are different types of replication in sql server?
