Interested to Buy Any Domain ? << Click Here >> for more details...
how many triggers we can create on a table
- 11 Answers
- 52155 Views
- G2 Technology, TCS, I also Faced
- E-Mail Answers
Answer Posted / samir
You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.
You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.
Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.
This information is available in Books Online
under "Triggers".
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is oracle open database communication (odbc)?
List the various oracle database objects?
What are the data types in oracle?
Is it possible to split the print reviewer into more than one region ?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Will you be able to store pictures in the database?
What is a connect identifier?
What is a cursor variable?
What are the ansi data types supported in oracle?
Explain the difference between sql and oracle?
Is there a function to split a string in plsql?
Where do you use decode and case statements?
what is the difference between substr and instr function in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
