Difference between Triggers and Stored Procedure
Answer Posted / pankaj arya
To use stored procedure you have to make a call to that
procedure but Triggers fired automatically when an event is
occurred on the table associated with that Trigger like add,
insert or delete.
| Is This Answer Correct ? | 108 Yes | 7 No |
Post New Answer View All Answers
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Explain important index characteristics?
How do I find the default sql server instance?
What is view in sql?
What is query processing?
What is triggers in ms sql server?
what is unique and xaml nonclustered index
What is the definition for sql server 2000?
Where do we use trace frag?
What do you understand by coalesce in sql server?
Can binary strings be used in arithmetical operations?
How many replicas are maintained for each SQL Azure database?
How do I find information about the install locations for the various instances running on a computer?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Can you type more than one query in the query editor screen at the same time?