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 are unicode character string data types in ms sql server?
What is isolation levels?
Different types of keys in SQL?
what is unique and xaml nonclustered index
What are trace flags?
Explain few examples of stored procedure over triggers?
How to create user messages with print statements in ms sql server?
Where actually sql azure database is hosted?
What are the different types of columns types constraints in the sql server?
Can you force a query to use a specific index?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is a cube? : sql server analysis services, ssas
Working with TLogs
How many databases instances are there in sql server 2000?
Can sql server 2016 run on windows 7?