Difference between Triggers and Stored Procedure
- 23 Answers
- 66922 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
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
Which data type columns are the best candidates for full-text indexing?
What is the difference between mysql and sql server?
What happens if the update subquery returns no rows in ms sql server?
Why should one not prefix user stored procedures with ‘sp_’?
Define ACID properties in a Database?
How to create a simple table to test triggers in ms sql server?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is query cost in sql server?
What is data source object?
mention different types of relationships in the dbms?
What are the different types of triggers in SQL SERVER?
Can sql servers linked to other servers?
How to use subqueries with the exists operators in ms sql server?
how to do partition in sqlserver
What is raid and what are different types of raid levels?
