Wht is the difference between stored procedure and trigger
Answer Posted / jerry joseph
Stored Procedures does not execute automatically
Triggers are a special type of Stored procedure which
executes automatically
Types of Triggers
- INSTEAD OF triggers
- AFTER Triggers
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What are the advantages of having an index on the sql server?
What is the difference between indexing and hashing?
How to declare and use cursor variables?
What is difference between stored procedure and user defined function?
What do you understand by coalesce in sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
How to delete database objects with "drop" statements in ms sql server?
What is rank function?
What is the use of @@spid?
How do use Having,Group by,Group function in SQL?
What is a trigger and its types?
Is port 1433 secure?
What is difference between Datepart() and Datename() in SqlServer?
Explain the Ways to improve the performance of a sql azure database?
What is a schema in ms sql server 2005?