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.

How to return the date part only from a sql server datetime datatype?

1103

---

List the types of recovery model available in sql server?

928

---

How to run sql server 2005 books online on your local system?

961

---

Explain about unique identifier data type in sql server?

920

---

What is the difference between clustered index and primary key?

922

---

Find first and last day of current month in sql server

1028

---

How many databases instances are there in sql server 2000?

1099

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

971

---

What happens if null values are involved in string operations?

993

---

What is data file in computer?

948

---

How to change server name in sql server?

1185

---

What is resultset concur_updatable?

1021

---

What are indexers?

1087

---

What are the drawbacks of reporting in ssrs?

150

---

How many primary keys are possible in a table?

926

---