Answer / Gagan Preet Singh Saini

{"Cursors in SQL Server are server-side or client-side temporary objects used to access and process rows one at a time from a result set. They can be used for looping through records, executing complex business logic on each record, and updating multiple records sequentially."

Why people hate cursor?

1 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

What are the types of database recovery models?

1 Answers   HCL,

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1 Answers  

---

What are different types of views?

1 Answers  

---

Explain indexed view?

1 Answers  

---

Can a unique index be created on a column, which contains null?

1 Answers  

---

What are joins in sql and what are the different types of joins?

1 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

what are the Prerequisites for Replication?

2 Answers   IBM,

---

How can you stop stored procedures from recompiling?

1 Answers  

---

Explain a checkpoint?

1 Answers  

---