Sql interview Question with Answers What is the sql server query execution sequence?
Download 0.79 Mb. Pdf ko'rish
|
SQL Interview Questions and Answers 1666806642
- Bu sahifa navigatsiya:
- 45. What are ‘inserted’ and ‘deleted’ tables (aka. magic tables)
43. What is a Trigger?
○ It is a precompiled set of TSQL statements that are automatically executed on a particular DDL, DML or log-on Follow Me : https://www.youtube.com/c/SauravAgarwal event. ○ Triggers do not have any parameters or return statement. ○ Triggers are the only way to access to the INSERTED and DELETED tables (aka. Magic Tables). ○ You can DISABLE/ENABLE Triggers instead of DROPPING them: DISABLE TRIGGER Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling © 2024 |