What is the difference between deallocate cursor and close cursor?

0 Answers  

---

How to create Clustered Primary Key to table?

2 Answers  

---

What is a file group?

0 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

How do I completely remove sql server instance?

0 Answers  

---

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

What is nolock?

0 Answers  

---

Tell me what are the essential components of sql server service broker?

0 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---