Answer Posted / hiral bhatt

Dear All,

Cursor, its an object in SQL Server and the main advantages
of cursor is that whenevr we need to fetch records in row
by row Manner..

But using cursor, it itself is not a good concept, we have
another alternate for cursor like Temp Table.

Regards
Hiral Bhatt
Sr. Software Engg.

Explain the working of sql privileges?

1146

---

List the types of recovery model available in sql server?

972

---

please differentiate between delete and truncate?

1041

---

what is the difference between Delete and Truncate command in SQL

1201

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1042

---

What is the xml datatype?

1125

---

What do you understand by user-defined function in the sql server?

1010

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1413

---

How to name query output columns in ms sql server?

1016

---

What are the methods used to protect against sql injection attack?

1120

---

What happens if null values are involved in bitwise operations?

1081

---

How to use the inserted and deleted pseudo tables?

1006

---

How network traffic be reduced by using the stored procedure?

1174

---

Explain indexes disadvantages?

1145

---

What is the cpu pressure?

1108

---