Interested to Buy Any Domain ? << Click Here >> for more details...
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 to search for a string in all stored procedure in sql server?
How to set database to be read_only in ms sql server?
What are functions in the sql server?
Define self join?
what is raid and what are different types of raid configurations? : Sql server database administration
what is hash nonclustered index
Difference between Logical Page and Physical Page in SSRS.
What happens if null values are involved in boolean operations?
What is the standby server?
How do I find the query plan in sql server?
How to scale out a federation by Sql statement?
What is the openxml statement in sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
explain different types of joins? : Sql server database administration
What are different replication agents and what's their purpose? : sql server replication
