What are the different types of joins and what does each do?

2 Answers  

---

What is filtered index?

0 Answers  

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What do you understand by coalesce in sql server?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

How to check parameter value in stored procedure sql server?

0 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

How connect excel to sql server?

0 Answers  

---

What are system databases into sql server (2005/2008)?

0 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

i want table name basis on column name.

5 Answers  

---