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 3nf normalization?
State a few properties of relational databases?
Explain user defined functions?
Alternative way to DetDate() function?
How to recreate an existing index in ms sql server?
How to add an address record into adventureworkslt?
How do you create a clustered index?
How can we solve concurrency problems?
What are sql servers used for?
What are the restraints imposed on the table design by a merge replication?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to change a login name in ms sql server?