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.

Answer / monika nargotra

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

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.

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.

Answer / sharma.dharmpal

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

Answer / sam katwal

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

How many triggers can be implemented for a table?

3 Answers   HSBC,

Can we use pl sql in mysql?

0 Answers  

How do you identify a primary key?

0 Answers  

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

How do I run a script in sql developer?

0 Answers  

Wat is SGA ?

3 Answers   ABB,

how to retrieve only duplicate values in a table

9 Answers  

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

What is a record in a database?

0 Answers  

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

Can I join the same table twice?

0 Answers  

How do you delete data from a table?

0 Answers