Answer / Sagar Kumar

A dynamic cursor in SQL Server is a cursor that is declared and opened dynamically during the execution of the program. It allows for iterating through rows of a result set that may not be known at compile time. However, using dynamic cursors can lead to poor performance due to their resource-intensive nature. In modern practice, they are often avoided in favor of more efficient solutions like Set-Based Programming.

How do I create a trace in sql server?

0 Answers  

---

What is the difference between a clustered index and a non-clustered index?

1 Answers  

---

How to delete existing rows in a table?

1 Answers  

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

what is the difference between a primary key and a unique key? : Sql server database administration

1 Answers  

---

What is collation sensitivity?

1 Answers  

---

What do you mean by a dependent functionality in a build?

1 Answers   HCL,

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

What is an example of a foreign key?

1 Answers  

---

Can a trigger be created on a view?

1 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---