Interested to Buy Any Domain ? << Click Here >> for more details...
is there more the two primary key in a single table?
- 26 Answers
- 32684 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
How does stuff differ from the replace function?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What are views used for?
How to concatenate two strings in SQL Server.
What authentication modes does sql server support?
What do you mean by stored techniques? How would we use it?
If a table does not have a unique index, can a cursor be opened on it?
What is raid, and how it can influence database performance?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is 1nf normalization form?
How to create prepared statements using odbc_prepare()?
What is the significance of null value and why should we avoid permitting null values?
How to change the password of a login name in ms sql server?
What is de-normalization in sql database administration? Give examples?
how to determine the service pack currently installed on sql server? : Sql server database administration
