Hi!,
This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:
"Secure way of executing Update statement in SQL Server"
Without transaction if any DML statement are executed in the database then that can be rolled back in sql server.
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!