Answer Posted / sid

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

When cursors are useful?

573

---

Why do we use non clustered index?

551

---

How to create a simple table to test triggers in ms sql server?

507

---

Can we use where clause with group by?

514

---

Does a server store data?

500

---

---

Explain datetime2 data type in sal server 2008?

545

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

498

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106

---

What is an example of a foreign key?

507

---

what is the difference between count(*) and count(1) ?

627

---

Can you force a query to use a specific index?

528

---

how can a database be repaired? : Sql server administration

514

---

What is the distinction amongst delete and truncate?

583

---

How to install sql server 2005 express edition?

590

---

How to list all field names in the result set using mssql_field_name()?

524

---