Hassle-free live chat software re-imagined for business growth. 2 users, always free.
but I do get no message returned and no record has been saved, while I did see @@TRANCOUNT is having the value of 2, right before the last "if" part. why?
... begin try insert into ... end try begin catch select @ErrorMessage=ERROR_MESSAGE(); if @@TRANCOUNT>0 begin rollback tran set @message='...' return end end catch if @@TRANCOUNT>0 begin commit tran set @message='...' end ...
|How to base a filter depending on fields contents?||15||48|
|Exchange 2010 - Best practice MDB Data size||8||49|
|SYNTAX PROBLEM -- adding another column into the stored procedure output||30||32|
|Splitting the content of a column in SQL||11||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!