Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73473 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
How to create view in stored procedure sql server?
How to provide default values to stored procedure parameters?
Explain rdbms?
Data table as parameter in sql server?
How to test values returned by a subquery with the in operator?
How to create an identity column?
What is the difference between indexing and hashing?
What is difference between temp table and cte?
Explain filtered indexes benefits?
How do you rebuild an identity column?
What is an index in sql?
What is the purpose of floor function?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain linked server in sql?
How can sql server instances be hidden? : sql server security
