2
Reply

What is difference between the stored Procedure and trigger?

Brijesh Jalan

Brijesh Jalan

Jul 15, 2010
10.4k
0

    1. ) SP may Return a value but Trigger Not,
    2.  ) In SP you can pass parameter But in trigger you can't
    3. ) we explicitly call the Sp when Trigger are implicitly
    fired
    4. ) you can write a sp in Trigger but in a Trigger you cant
    write SP.
    5.) Trigger written on an individual Table or View where SP
    is written for an Database

    mistry nilay
    October 26, 2010
    0

    Store Procedure:-

    1.Store procedure is a named group of sql statement that is previously created and stored in sql data base.

    2.Store Procedure is pre compiled

    3.Store procedure can have insert,select,delete,update and search statement.

    4.when you want to modify logic inside procedure you can do it without affecting any client.changes will reflect immediatly.

    Trigger:-

    1.Trigger is special type of store procedure that responds on specific events like as Insert,Update or Delete.

    2.You can not force trigger directly.it automatically responds when corresponding action take place on that table where it defined.

    3.Triggers are managed by DBMS.

    4.Triggers are used to maintain referiantel Integrity of data base.

    Aisshwary Singh
    July 26, 2010
    0