Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

What are the differentTrigger types in SQL Server

Feb 2 2012 11:06AM by Szymon Wojcik   

Question

Based on action, what are the trigger types in SQL Server and when are they executed?

Answer

There are three types of triggers:

  • DML triggers - executed when data in a table is modified (for INSERT, UPDATE or DELETE statement)
  • DDL triggers - executed when certain DDL statements are executed (both database and server level)
  • Logon triggers - executed when user logs on

DML triggers can be defined as INSTEAD OF, AFTER or BEFORE. DDL and logon triggers can be defined as FOR or AFTER.

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Szymon Wojcik
67 · 3% · 877
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"What are the differentTrigger types in SQL Server" rated 5 out of 5 by 3 readers
What are the differentTrigger types in SQL Server , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]