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
Explain active/passive and active/active cluster configurations?
How to delete multiple rows with one delete statement in ms sql server?
What are commonly used odbc functions in php?
Explain different types of locks in sql server.
What is SQL Azure Firewall?
What language is sql server written in?
What is clr ddl trigger?
What are the tool windows in sql server management studio? : sql server management studio
How to use copy and concatenate commands in SQL?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How would we use distinct statement? What is its use?
What is the difference between function and stored procedure in sql server?
List the different types of joins?
What is change data capture (cdc) in sql server 2008?
What are the difference between primary keys and foreign keys?