Answer Posted / rajkumar v

SQLserver2000
There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

SQLserver2005

3 types:

1. DML,
2. DDL &
3. CLR

how to invoke a trigger on demand? : Sql server database administration

1086

---

How to connect ms access to sql servers through odbc?

1030

---

what is denormalization and when would you go for it? : Sql server database administration

1188

---

What is a non clustered primary key?

925

---

Is sql server free?

917

---

When would you use the stored procedures or functions?

1000

---

What is proper subset of candidate key?

996

---

What are group functions in query statements in ms sql server?

1010

---

What is a transaction and why is it important?

1091

---

Do you know what is fill factor and pad index?

1004

---

What is a user-defined function in the sql server and what is its advantage?

1105

---

What is bcp? When does it use?

943

---

What is instead of trigger sql server?

1001

---

What is the difference between clustered and non-clustered indexes in ms sql server?

1001

---

Mention the uses of stored procedures.

970

---