Thread: Stored Procedures

Stored Procedures

From
"Kent Anderson"
Date:
This is a real novice question, sorry if it doesn't make much sense.
 
We are currently switching to stored procedures for a lot of our database activity. The question has come up about the transactional nature of the stored procedures.  I was wondering if stored procedures can have transactions or if you must start the transaction in your code and call the stored procedure from there to get the safety of a transaction?
 
Thanks
Kent Anderson