Difference between Triggers and Stored Procedure
- 23 Answers
- 69420 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / j.shantha kumari
Set of Sql statements called stored procedure.
The SQL CREATE TRIGGER statement provides a way for the
database management system to actively control, monitor, and
manage a group of tables whenever an insert, update, or
delete operation is performed. The statements specified in
the SQL trigger are executed each time an SQL insert,
update, or delete operation is performed. An SQL trigger may
call stored procedures or user-defined functions to perform
additional processing when the trigger is executed.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between ms sql server reporting services vs crystal reports?
What is extended stored procedures?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is parameterized reports in ssrs ?
Explain the difference between delete,drop and truncate in SQL Server?
What happens if the update subquery returns no rows in ms sql server?
How to use group functions in the select clause in ms sql server?
What is difference between clustered index and non clustered index?
explain the storage models of olap? : Sql server database administration
Other than truncate statement, which other command can by-pass the trigger on the tables?
How do you make a trace?
Describe in brief system database.
How does using a separate hard drive for several database objects improves performance right away?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
How to test subquery results with the exists operator?
