Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Question Unanswered: Store Procedure, Trigger

    Hi All,

    I'm new in programming... may I know what's the benefit of using Store Procedure compare to using traditional coding in the application and what's the trigger for??

    Thanks.
    Last edited by ultraman76; 10-22-04 at 11:38.

  2. #2
    Join Date
    Nov 2003
    Location
    Lomza, POLAND
    Posts
    81
    Both stored procedure and trigger are executed on the same machine where the database is located. The main advantage is that the data needed for a stored procedure (or trigger) is not sent through the network. In this way you can increase the performance.
    Triggers are thought to keep data integrity.
    Best regards
    Bogdan Brzozowski

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •