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
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Do you know what is rank function?
What is temporary table in sql server? Why we use temp table?
Explain the dirty pages?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to use subqueries in the from clause in ms sql server?
Difference between primary key and clustered index?
How to list all tables in the database using odbc_tables()?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How to enter binary string literals in ms sql server?
What is the use of nvl work?
How to drop an existing schema in ms sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What happens if ntwdblib.dll is missing on your machine?
What is difference between standardization and normalization?
