BEGIN AND END INSIDE TRY BLOCK

It's fine. The standard Error Handling in T-SQL is TRY/CATCH block. For more info please see this article:

Error Handling in SQL 2005 and Later

---

The most important motivation for the research work that resulted in the relational model was the objective of providing a sharp and clear boundary between the logical and physical aspects of database management. - E. F. Codd





My blog