![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions Latest Answer : Trigger is a self executing event in sql server where a relevent action is occured.triggers are useful in master-child relation ship in a table.Trigger can be created as,create trigger triggername on tablename for insert,update,delete as "necessory ... Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no. Read Answers (11) | Asked by : laxman What will you do if a trigger fails during execution? Latest Answer : Does it fail all the time? Did it run before? Most trigger issuses are with datatype mismatches or constraint voiolations . Run the DML statement in a SSMS query to see what the error message is. ... Is there any reason for which we cannot use After trigger with a view? Latest Answer : after trigger is used for complex views ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||