Difference between Triggers and Stored Procedure
Answer Posted / naveen jindal
trigger fired implicitely that is when ever events like
insert/update/delete commands.
Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is difference between rollback immediate and with no_wait during alter database?
How to change the name of a database user?
How to find the second highest salary of an employee?
Explain what is raid and what are different types of raid levels?
What is the difference between for auto and for nested?
How to provide login information for a new odbc dsn?
What is format parameter in ssrs?
How do I start sql server?
Can binary strings be converted into numeric or float data types?
What is report subscription?
how would you troubleshoot blocking? : Sql server database administration
How many full-text indexes can a table have?
What is sub-query in sql server? Explain its properties.
What are translations and its use? : sql server analysis services, ssas
When to use Inner join & when to use subquery?