Answer Posted / srinivas

int

Explain about link server in sql server?

735

---

Define inner join in sql server joins?

714

---

What is ems sql management studio? : sql server management studio

758

---

What is explicit cursors?

733

---

Can we use having clause without group by?

732

---

---

What is report rendering ?

131

---

How to generate create procedure script on an existing stored procedure?

694

---

What is the difference between migration and upgradation in sql server?

790

---

Which is better statement or preparedstatement?

692

---

Difference between report and query parameter.

799

---

What is the filtered index?

772

---

Why are sql functions used?

770

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4011

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

677

---

Explain the difference between function and stored procedure?

681

---