Determine when to use stored procedure to complete sql server tasks?
What is extended stored procedures?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What security features are available for stored procedure?
What is stored procedures?
In what three ways is the return statement used in a stored procedure?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
Explain syntax for viewing, dropping and disabling triggers?
Explain triggers?
How to apply cascading referential integrity in place of triggers?
How to invoke a trigger on demand?
What is ms sql server triggers?
What are the instances when triggers are appropriate?
How many triggers you can have on a table?
Determine how to use the inserted and deleted pseudo tables?