Answer Posted / devendra sharma

Yes it is possible that a primary key can be non clustered

create table abc(eid int PRIMARY KEY
NONCLUSTERED,ename varchar(50),vid int)

create clustered index abc_clustered on abc (vid)


now if you will check the index on eid cloumne it will be
unique and vid will have a clustered index.

Give it a try if you don't belive......

What is a database in ms sql server?

1057

---

What is the difference between Clustered and Non-Clustered Index?

1059

---

How to modify an existing stored procedure in ms sql server?

1079

---

What is the downside of using udf?

1109

---

Explain having clause and where clause?

1055

---

Can we create clustered index on composite key?

1082

---

can a database be shrunk with users active? : Sql server administration

1006

---

What are the methods used to protect against sql injection attack?

1065

---

What is the significance of null value and why should we avoid permitting null values?

986

---

what is database replication? : Sql server database administration

1062

---

How sql server enhances scalability of the database system?

1215

---

What is instead of trigger sql server?

999

---

Name some of the open source software that you can use in alternative to SSR?

161

---

What do you understand by user-defined function in the sql server?

951

---

what is an extended stored procedure? : Sql server database administration

1055

---