Difference between Triggers and Stored Procedure
- 23 Answers
- 69343 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / veerababu
Stored Procedure is a method.
Trigger is a Procedure.
Stored Procedure a specific CALL or EXECUTE has be used.
Trigger is automatically execute some specific events occure in table/views.
Stored Procedure return a Value.
Trigger is not return a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to get the definition of a view out of the sql server?
Explain the etl (extraction, transformation, and loading)?
What is the Difference Between Primary and Foreign Key?
What is the difference between functions and stored procedures?
What is for xml in sql server?
What is the return type of executeupdate ()?
What is CTE in SQL
What is the difference between function and stored procedure in sql server?
What is data mart? : sql server analysis services, ssas
How will you hide an attribute? : sql server analysis services, ssas
What does ss stand for sexually?
How to write a query with a full outer join in ms sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to add code to the existing article (using improve article)?
What are the different types of upgrades that can be performed in sql server?
