1. What is Trigger?
2. What is its user?
3. What are the types of Triggers?
4. What are the new kinds of triggers in sql 2000?
5. When should one use " insted of Trigger"?
6. Difference between trigger and stored procedure?
7. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
8. There is trigger defined for INSERT operations on a table. in an OLTP system. The trigger is written to instantiate a COM object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
9. Which virtual table does a trigger use?
10. What are the types of Triggers?
11. What will be query used to get the list of triggers in a database?
12. What are magic tables in sql server?
13. Can i invoke/instantiate COM objects from within stored procedures or triggers using T-SQL?
14. What are the pros and cons of using triggers?
15. What is CLR?
16. What is the order of execution of multiple triggers?
17. The difference between instead of trigger and after trigger?
18. Can i change the sequence of firing a trigger, if yes how?
19. What is direct a regression triggers, how to disable this feature in SQL Server - 2008?
20. What is indirect regression?
2. What is its user?
3. What are the types of Triggers?
4. What are the new kinds of triggers in sql 2000?
5. When should one use " insted of Trigger"?
6. Difference between trigger and stored procedure?
7. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
8. There is trigger defined for INSERT operations on a table. in an OLTP system. The trigger is written to instantiate a COM object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
9. Which virtual table does a trigger use?
10. What are the types of Triggers?
11. What will be query used to get the list of triggers in a database?
12. What are magic tables in sql server?
13. Can i invoke/instantiate COM objects from within stored procedures or triggers using T-SQL?
14. What are the pros and cons of using triggers?
15. What is CLR?
16. What is the order of execution of multiple triggers?
17. The difference between instead of trigger and after trigger?
18. Can i change the sequence of firing a trigger, if yes how?
19. What is direct a regression triggers, how to disable this feature in SQL Server - 2008?
20. What is indirect regression?
No comments:
Post a Comment