trigger/stored procedure examples?

[David Jencks]

So I don't spend hours looking in the wrong places.... are there any  
examples of how to set up and use triggers or stored procedures that  
work against trunk?

thanks
david jencks