Answer / Ajit Singh

A table in SQL Server can have only one primary key and, consequently, one clustered index. If you attempt to create a second clustered index, the server will fail and return an error.

Explain in brief about Microsoft SQL server?

1 Answers  

---

Tell me what is use of except clause? How it differs from not in clause?

1 Answers  

---

How do I view a trc file?

1 Answers  

---

Define msdb database?

1 Answers  

---

What are the restrictions while creating batches in sql server?

1 Answers  

---

What are different types of statement?

1 Answers  

---

What stored by the model?

1 Answers  

---

What is tabulation?

1 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Can group functions be used in the order by clause in ms sql server?

1 Answers  

---

What command is used to rename the database?

1 Answers  

---

What is SubQuery in SQL Server 2008

1 Answers   HCL,

---