Answer Posted / vinay singh

There are no more than one Primary Key in a single table,
but we can make a Primary key using combination of more than
one column...
Example..

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]

** Vinay Singh
** Cell No - 9867774724

What is data modification?

898

---

Does order by actually change the order of the data in the tables or does it just change the output?

1083

---

Explain comment on transactions?

936

---

Find first and last day of current month in sql server

978

---

How to create a user name in a database?

996

---

How do I find the transaction log size in sql server?

916

---

How can you set the threshold at which sql server will generate keysets asynchronously?

940

---

Explain the working of sql privileges?

1041

---

What is replication with database mirroring? : sql server database administration

988

---

Explain trigger classes i.e. Instead of and after trigger?

826

---

What are the different types of subquery?

1098

---

How do you size a resultset?

878

---

What are the properties of sub-query?

1027

---

How you would rewrite the sql query to return the customerid sorted numerically?

938

---

How do I find my localdb version?

941

---