Difference between Triggers and Stored Procedure
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
What does the update command do?
What do you understand by sql server agent?
How to connect sql server management studio express to sql server 2005 express?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is the recursive stored procedure in sql server?
How can you set the threshold at which sql server will generate keysets asynchronously?
Who is the owner of a schema in ms sql server?
Can you insert NULL in unique column?
What are the mathematical functions supported by sql server 2005?
Explain the steps to create and execute a user-defined function in the sql server?
Can we add our custom code in ssis?
How to change server name in sql server?
Explain the architecture of ms sql reporting service?
How to disable a login name in ms sql server?
When I run the sql server 2000 setup, it just hangs. What do I do?