Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between after trigger and
instead trigger.
- 2 Answers
- 19820 Views
- I also Faced
- E-Mail Answers
Answer Posted / durga prasad
After Trigger fires an operation after any
insert,update,delete operations performed on a table.
Instead Of Trigger fires an operation instead of performing
user specified operation.
u can create instead of trigger on views but u can not
create after triggers on views
| Is This Answer Correct ? | 38 Yes | 5 No |
Post New Answer View All Answers
What is temporal table?
Is it ok to shrink transaction log?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is the purpose of data source?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How can we get count of the number of records in a table?
What is the filtered index?
What is the use of partition by in sql server?
According to you what goes into making the best database administrator? : sql server database administration
What stored procedure would you use to view lock information?
when would you go for denormalization? : Sql server database administration
Explain what is the use of custom fields in report?
Explain having clause and where clause?
Explain the third normal form(3nf)?
What are different types of roles provided by ssrs?
