Answer Posted / learner

triggers use 2 virtual tables called OLD and NEW.

How to fetch the next row from a cursor with a "fetch" statement?

595

---

What are the differences between sql server and mysql.

534

---

Explain syntax for viewing trigger?

544

---

What is a DBMS, query, SQL?

577

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

501

---

---

What is dirty page?

568

---

What is difference between view and materialized view?

542

---

How many ways to create table-valued functions?

586

---

In which tcp/ip port does sql server run? Can it be changed?

550

---

What is nested transaction?

538

---

What do you think of this implementation? Can this be implemented better?

536

---

Does transparent data encryption provide encryption when transmitting data across the network?

632

---

Is sql server free?

529

---

How can you insert values in multiple rows using one Insert statement?

623

---

Explain the different types of backups available in sql server? : sql server database administration

523

---