Difference between Triggers and Stored Procedure
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
What is checkpoint in sql server?
What is the correct order of the logical query processing phases?
What is the difference between Triggers and Stored Procedure?
What are the new scripting capabilities of ssms? : sql server management studio
What happens if null values are involved in boolean operations?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is a dbms wizard?
last function used in MS Access to convert sql what function will use in sql
Why is the need for data conversion transformations?
What is SubQuery in SQL Server 2008
What is always encrypted?
Which are new data types introduced in sql server 2008?
What are the advantages of partitioning?
Tell me can we use custom code in ssrs?
Explain indexed views and partitioned view with their syntax.