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