How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 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  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

What is difference between drop truncate and delete?

0 Answers  

---

what's sql server? : Sql server database administration

0 Answers  

---

How to list all user defined functions in the current database?

0 Answers  

---

Is oracle faster than sql server?

0 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

How can sql server instances be hidden? : sql server security

0 Answers  

---