Answer Posted / jerry joseph
Triggers are a special type of Stored procedure which
execute automatically when a triggering action like INSERT,
UPDATE or DELETE occurs.
INSTEAD OF trigger
- executes automatically in place of triggering actions like
INSERT, UPDATE or DELETE
- executes before PK, FK constrains are checked
AFTER trigger
- executes automatically after the statement that triggered
it completes
- executes after constrains are checked
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How exceptions can be handled in sql server programming?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What happens when converting big values to integers?
How we can refresh the view?
What is ssrs?
How to execute a sql statement using odbc_exec()?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are the types of containers in ssis?
What are the default system databases in sql server 2000?
What are the basic functions for master, msdb, model, tempdb and resource databases?
How to drop an existing table?
What are types of storage modes? : sql server analysis services, ssas
What is sql server database?
Why use view instead of a table?
