Learn how to use TRY...CATCH blocks to control the flow of stored procedures in SQL Server. Find out their benefits, limitations, and best practices.

1.Do not use empty catch blocks. 2.Try to catch specific exceptions than general exception class. For example 'FileNotFound' exception. This will give you more detailed information on what went wrong.