How to convert a table data in XML format in sql server?

0 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

---

How to use group functions in the select clause in ms sql server?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

How can I get data from a database on another server?

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’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

What are the pros and cons of creating extended stored procedures?

1 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---