Stored Procedures does not execute automatically Triggers are a special

Wht is the difference between stored procedure and trigger

Question Posted / jerry joseph

6 Answers
14849 Views
HCL, TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the advantages of having an index on the sql server?

925

What is the difference between indexing and hashing?

1169

How to declare and use cursor variables?

1172

What is difference between stored procedure and user defined function?

1107

What do you understand by coalesce in sql server?

1072

What is the use of keyword with encryption. Create a store procedure with encryption?

960

How to delete database objects with "drop" statements in ms sql server?

1089

What is rank function?

1033

What is the use of @@spid?

1001

How do use Having,Group by,Group function in SQL?

1746

What is a trigger and its types?

991

Is port 1433 secure?

997

What is difference between Datepart() and Datename() in SqlServer?

1206

Explain the Ways to improve the performance of a sql azure database?

What is a schema in ms sql server 2005?

970