Answer Posted / chandan

1.Model
2.Tempdb
3.msdb
4.master

Can you use order by when defining a view?

571

---

How to transfer data from a cursor to variables with a "fetch" statement?

582

---

What do we need queues in sql service broker?

522

---

What is difference between clustered and non clustered index?

528

---

What is a non equi join?

540

---

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

515

---

Tell me what is sql profiler?

618

---

Can you type more than one query in the query editor screen at the same time?

572

---

What is the recursive stored procedure in sql server?

523

---

What is difference between after and before?

504

---

When should you use an instead of trigger?

549

---

What is a covering index?

530

---

What are character string data types in ms sql server?

628

---

Write query to return all rows sql?

613

---

What are the lambda triggers?

483

---