Short: SQL Update using begin try and begin transaction
Commit and Rollback command
Begin Transaction
A simple video showing you how to do an update using begin try, begin transaction, begin catch, commit and rollback.
Related articles
How to call a function inside my SQL Server?
Database function function and function
How to create an SQL to do multiple inserts in one statement?
Practical examples
Getting the last 120 months of data from my database
how to do it in SQL language?
Mauricio Junior