Answer / swetha

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.

Answer / anand

3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005

DDL and LOGON are used to administrator related tasks

Answer / yugal

SQL Server 2008 includes three general types of triggers:

1)DML triggers
2)DDL triggers
3)Logon triggers.

Answer / devipriyanka

Types of Triggers

* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)

Answer / balaji

which one is correct?
ISthis DML,DDL,CLR or Instead of trigger, after trigger

Answer / 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

Answer / touhid

3

Answer / abcd

3 types:

1. DML,
2. DDL &
3. CLR (is it right?)

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

What is store procedure?

0 Answers  

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

How to read data in a table with "select" statements?

0 Answers  

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

What is optimistic concurrency?

0 Answers  

Can two tables share a primary key?

0 Answers  

How to generate create function script on an existing function?

0 Answers  

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

What is a covered index?

0 Answers