Answer Posted / Supriya Chaudhary
"Triggers are special types of stored procedures that automatically execute in response to specific events on a database object such as insert, update, or delete. There are four types of triggers in SQL Server: INSERT trigger (fires when new data is inserted), UPDATE trigger (fires when existing data is modified), DELETE trigger (fires when existing data is deleted), and AFTER trigger (fires after the event has occurred) and DDL Triggers (fires when any schema change happens on a database object)."n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is standby servers? Explain types of standby servers.
What is sql or structured query language?
What are the properties of the transaction?
What is normalization and what are the advantages of it?
How to enter binary string literals in ms sql server?
What is a scheduled job or what is a scheduled task?
What are the different SQL Server Versions you have worked on?
What is sql server query analyzer?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Why use identity in sql server?
What are the kinds of subquery?
What is subquery? Explain the properties of a subquery?
Does view occupy space?
Why and when do stored procedure recompile?
How to rebuild the master database?
