Explain some DBCC commands?

6 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

How to create a simple table to test triggers in ms sql server?

0 Answers  

---

Explain about the command-line tool SQLCMD?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

---

How many triggers are possible per table?

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

Can two tables share the same primary key?

0 Answers  

---

How does a profiler work?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What is the difference between locking and multi-versioning?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---