Answer Posted / yoshita kundwani

Cursors can be considers as named result sets which allow a
user to move through each record one by one.

What are the dis_advantages of stored procedures, triggers, indexes?

2273

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1084

---

How to see the event list of an existing trigger using sys.trigger_events?

1126

---

Difference between Sql server reporting services and Crystal reports?

175

---

How to use "begin ... End" statement structures in ms sql server?

1115

---

What is bcnf normalization form?

1158

---

What is inner join? Explain with an example?

1279

---

What is sql server english query?

1196

---

How to display a past time in days, hours and minutes?

1058

---

Explain triggers in sql?

1001

---

Which tcp/ip port does the sql server run on? How can it be changed?

1099

---

What is 1nf 2nf and 3nf?

952

---

What is the usage of sign function?

1171

---

Which is better statement or preparedstatement?

982

---

Do you know how to make remote connection in database?

1006

---