Answer Posted / pawan378

above answers are correct.
let me add some thing.

Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.

Tell me the phases a transaction has to undergo?

550

---

How to Insert multiple rows with a single insert statement?

547

---

What is the difference between mysql and mysqli?

581

---

Can you explain full-text query in sql server?

548

---

What is SQL Azure?

85

---

---

What is report server project?

106

---

When would you use the stored procedures or functions?

576

---

How ssrs maintain security?

583

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

638

---

How do you size a resultset?

500

---

what stored procedure would you use to view lock information? : Sql server administration

582

---

How to drop an existing user defined function in ms sql server?

564

---

what is the difference between a primary key and a unique key? : Sql server database administration

529

---

What are the tool windows in sql server management studio? : sql server management studio

624

---

What are the recovery models in sql server 2000?

563

---