Database - SQL Server 2000 - Discussion

Discussion Forum : SQL Server 2000 - True or False (Q.No. 17)
17.
SQL Server AFTER Triggers may be assigned views.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
1 comments Page 1 of 1.

Vinita said:   1 decade ago
AFTER trigger specifies that the trigger is fired only when all operations specified in the triggering SQL statement have executed successfully. All referential cascade actions and constraint checks also must succeed before this trigger executes.

AFTER is the default, if FOR is the only keyword specified.

AFTER triggers cannot be defined on views.

Post your comments here:

Your comments will be displayed after verification.