Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 74286 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
What is the latest version of microsoft sql server?
How do I view a stored procedure in sql server query?
Which are ddl commands?
Why should one not prefix user stored procedures with ‘sp_’?
What are the difference between “where” and “having” clause in sql server?
Explain the concepts and capabilities of sql server?
What is a fan-out query in SQL Azure?
What does this statement do @@rowcount?
What is use of dbcc commands?
What is the library index called?
Explain differentiate between a having clause and a where clause?
Explain following error properties?
What is row_number()?
What happens if null values are involved in boolean operations?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
