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 does ss stand for sexually?

1143

---

What are different types of constraints?

968

---

How to transfer data from a cursor to variables with a "fetch" statement?

1141

---

Can we install sql server 2016 on windows 7?

1191

---

What does top operator do?

1074

---

How will you hide an attribute? : sql server analysis services, ssas

1010

---

What is buffer cash in sql server?

1203

---

what are database files and filegroups? : Sql server database administration

996

---

What is efficiency data?

1002

---

What types of replication are supported in sql server?

1112

---

When would you use it?

1041

---

Give the query of getting last two records from the table in SQL SERVER?

1008

---

Can binary strings be converted into numeric or float data types?

1094

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1060

---

What is difference between materialized view and view?

951

---