what is the difference between trigger and storedprocedures

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / yuva

16 Answers
32517 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between trigger and storedprocedures..

Answer / bhanu verma

Actually triger in action which is performed automatically
before or after a event occur and stored procedure is a
procedure which is executed when the it is called.

Is This Answer Correct ?

0 Yes

0 No

what is the difference between trigger and storedprocedures..

Answer / monika nargotra

triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.

Is This Answer Correct ?

0 Yes

0 No

what is the difference between trigger and storedprocedures..

Answer / srikanth

Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.

triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.

Is This Answer Correct ?

0 Yes

0 No

what is the difference between trigger and storedprocedures..

Answer / nandkumar

There are bascis 3 difference between them
1> trigger invokes implicitly while we need to invoke
procedure explicitly.
2> We cant pass values from user to trigger but we can pass
values into procedure.
3> Trigger cant return value procedure can return value.

Is This Answer Correct ?

0 Yes

0 No

what is the difference between trigger and storedprocedures..

Answer / sharma.dharmpal

One more difference is that Trigger is compiled code where
as stroed procedure is not.

Is This Answer Correct ?

4 Yes

16 No

what is the difference between trigger and storedprocedures..

Answer / sam katwal

Both are Same
Triggers are special Stored Producedures which are created
by User whereas Stored Procedures are created by the System.

Is This Answer Correct ?

2 Yes

20 No

Post New Answer