wood burning stoves 2.0*
The moose likes JDBC and the fly likes diff b/w stored proc and triggers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "diff b/w stored proc and triggers" Watch "diff b/w stored proc and triggers" New topic

diff b/w stored proc and triggers

pravanya Gullapudi

Joined: May 07, 2007
Posts: 16
difference between stored procedures and triggers?
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Did you try googling, or reading your database's documentation? Either source is liable to give you a fuller answer than one you will get here. The basics are a trigger is something that happens on specific events in the database, a stored procedure is a piece of functionality stored and run in the database.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: diff b/w stored proc and triggers
Similar Threads
Stored procedures in MSAcess
what are procedures in sql ?
HF-SQL: Stored Procedures & Triggers
how to automatically detect a row insertion in database
invoking a trigger