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.

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

How global cursor can be declare with dynamic trigger ?

0 Answers  

how would concatenate strings in mysql? : Sql dba

0 Answers  

what are the types of subquery? : Sql dba

0 Answers  

what are rollup and cube in t-sql? : Transact sql

0 Answers  

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

discuss about myisam index statistics collection. : Sql dba

0 Answers  

Is oracel sql developer written in java?

0 Answers  

Is delete faster than truncate?

0 Answers  

Does truncate free space?

0 Answers  

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers