Answer Posted / sd

Cursors allow row-by-row prcessing of the resultsets.

Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven

Why I am getting this error when dropping a database in ms sql server?

1059

---

What is compound operators?

1032

---

Name few of the dcl commands in sql?

990

---

What is the difference between mysql and mysqli?

1167

---

Can you please explain the difference between primary keys and foreign keys?

1092

---

What are the advantages of the mirroring?

1058

---

State the difference between union and union all?

918

---

How do you create an execution plan?

926

---

What is used to replicate sessions between instances in coldfusion clusters?

1055

---

What is the difference between stored procedure and user defined functions?

1174

---

How to loop through returning rows?

1016

---

Find nth lowest salary or get nth lowest salary?

1007

---

What is acid properties?

1075

---

What do you understand by triggers and mention the different types of it?

905

---

What is the function of sql server agent windows service?

1067

---