Answer / Mukul Kumar

To work with a cursor in SQL Server, you must follow these steps:
1. Declare the cursor using the DECLARE statement.
2. Open the cursor using the OPEN statement.
3. Fetch rows from the cursor using the FETCH statement.
4. Optionally, perform operations on the fetched row(s).
5. Close the cursor using the CLOSE statement.
6. Deallocate the cursor using the DEALLOCATE statement.

What happens when transaction log is full?

1 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1 Answers  

---

Do you know what is difference between stored procedure and user defined function?

1 Answers  

---

What is a fill factor?

1 Answers  

---

Can sql server be linked with other servers like oracle?

1 Answers  

---

What is xdr?

1 Answers  

---

Does hive support indexing?

1 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1 Answers  

---

Can we use where and having clause together?

1 Answers  

---

Tell me what is the stuff and how does it differ from the replace function?

1 Answers  

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

Why the trigger fires multiple times in single login?

1 Answers  

---