what is diffrent between store procedure and trigger
Answers were Sorted based on User's Feedback
Answer / vandana chand
Stored Procedure is the set of SQl statements together in the
data base.
and Trigger is the Special kind of store procedure i.e called
whenever an attempt is to modify the data.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sankar
1)Actually Trigger is an action which is performed
automatically after or before an event occure. But Store
procedure is executed when it is call.
2)We can call Trigger inside the store procedure. But
reverse is not possible.
Is This Answer Correct ? | 1 Yes | 2 No |
What is ems sql management studio? : sql server management studio
How fixed length strings are truncated and padded?
Can we create clustered index on composite key?
What is sql sandbox in sql server?
Why is normalisation important?
Why functions are used in sql server?
How to create new tables with "select ... Into" statements in ms sql server?
How to create a testing table with test data in ms sql server?
What information is maintained within the msdb database?
What are the properties of the transaction?
What is the latest version of microsoft sql server?
Does sql server 2016 have ssms?