Saved Bookmarks
| 1. |
What Triggers Does Sql Server 2000 Support? |
|
Answer» SQL Server 2000 SUPPORTS INSTEAD OF and AFTER triggers only. There is no SQL Server support for BEFORE triggers. A table may have ONE or more AFTER triggers for INSERT, update and delete actions; AFTER triggers may not be assigned to views. A view or table may have at most one INSTEAD OF TRIGGER for each triggering action of insert, update or delete. SQL Server 2000 supports INSTEAD OF and AFTER triggers only. There is no SQL Server support for BEFORE triggers. A table may have one or more AFTER triggers for insert, update and delete actions; AFTER triggers may not be assigned to views. A view or table may have at most one INSTEAD OF trigger for each triggering action of insert, update or delete. |
|