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

Define Unique Key?

941

---

How to drop an existing table?

957

---

What is the difference between online clustering and Offline clustering?

2356

---

How do I debug a stored procedure in sql server?

1026

---

How to populate a table in sql server?

891

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

959

---

What is difference between delete & truncate commands?

1022

---

Define views.

960

---

What is 2nf normalization?

966

---

What is query processing?

880

---

What are the various editions of sql server 2017 that are available in the market?

843

---

Write a sql query to get zero records from a table having n number of records?

1128

---

What is an expression in ms sql server?

1012

---

What is database architecture? : SQL Server Architecture

973

---

What is a performance monitor?

920

---