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
Difference between uniqe index and uniqe constraint?
What is a transaction and why is it important?
What is the current pricing model of SQL Azure?
Write the syntax for stuff function in an sql server?
Why are you getting errors when creating a new odbc dsn?
What do you understand by physical_only option in dbcc checkdb?
Explain ranking functions?
What is transact-sql language?
What is spatial and temporal data?
What are the basic features of a trigger in ms sql server?
What is primary key index?
List the different index configurations possible for a table?
Is natural join and equi join same?
Explain the advantages of merge replication?
Why can there be only one clustered index and not more than one?