Re: [GENERAL] basic stored proc/transaction question

2006-03-24 Thread Ben
Well, that's awesome. Thanks! On Fri, 24 Mar 2006, Ian Harding wrote: On 3/24/06, Ben <[EMAIL PROTECTED]> wrote: My understanding is that a stored procedure does an implicit begin/commit when it executes. Maybe my brain isn't working so well this morning, because I can't figure out how I would

Re: [GENERAL] basic stored proc/transaction question

2006-03-24 Thread Ian Harding
On 3/24/06, Ben <[EMAIL PROTECTED]> wrote: > My understanding is that a stored procedure does an implicit begin/commit when > it executes. Maybe my brain isn't working so well this morning, because I > can't > figure out how I would do: > > begin; > call stored proc; > call another stored proc; >

[GENERAL] basic stored proc/transaction question

2006-03-24 Thread Ben
My understanding is that a stored procedure does an implicit begin/commit when it executes. Maybe my brain isn't working so well this morning, because I can't figure out how I would do: begin; call stored proc; call another stored proc; commit; It seems that the transaction would be committed