Is trigger fired implicitely?

Question Posted / d

Answers were Sorted based on User's Feedback

Is trigger fired implicitely?..

Answer / jay vardhan singh

Yes,
Trigger cannot be fired explicitly.We cannot call trigger .
It fires automatically on event.

Is This Answer Correct ?

9 Yes

0 No

Is trigger fired implicitely?..

Answer / sivasankardoss

No, Trigger cannot be fired implicitely. Only a DML
statement can invoke a trigger.

Is This Answer Correct ?

1 Yes

6 No

More SQL Server Interview Questions

What do you understand by replication in sql server?

Explain what are the restrictions that views have to follow? : SQL Server Architecture

What is the use of partition by in sql server?

what is denormalization? : Sql server database administration

How many types of cursor type are there?

Write a code to select distinct records without using the DISTINCT keyword.

How to encrypt data between dialogs?

What is attribute hierarchy? : sql server analysis services, ssas

How to round a numeric value to a specific precision?

Why SQL Agent is used?

if no size is defined while creating the database, what size will the database have? : Sql server administration

What is the security model used in sql server 2005?

For more SQL Server Interview Questions Click Here