Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73616 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 ssrs?
between cast and convert which function would you prefer and why?
What are sql server procedures?
what is the different types of backups available in sql server? : Sql server database administration
What are the basic functions for master, msdb, model, tempdb databases?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How to populate a table in sql server?
How can a database be repaired?
How to convert a numeric expression from one data type to another?
List out what other servers you can use with ssrs?
What are the extra roles available in msdb? : sql server security
What do you need to connect php to sql server?
What is lookup override?
What are sparse columns?
Is it important for a database administrator to understand the operating system and file access?
