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.