Try Catch in SQL

Question

How write a query in SQL using TRY CATCH in TRIGGER

Rajeesh Menoth · Answer

Hi BEGIN TRY SELECT * FROM sys.messages WHERE message_id = 21; END TRY GO -- The previous GO breaks the script into two batches -- generating syntax errors. The script runs if this GO -- is removed. BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber; END CATCH; GO More Details : https://technet.microsoft.com/en-us/library/ms179296(v=sql.105).aspx