I'm using sqlserver 2014 and trying to create a
StoredProcedure inside try-catch block like this:
BEGIN TRY CREATE PROCEDURE [ammeghezi1] (@w INT) AS SELECT '' END TRY BEGIN CATCH ... END CATCH
It fails to run with the error of:
Incorrect syntax near 'SELECT' Expecting EXTERNAL.
Then i changed sp like:
CREATE PROCEDURE [ammeghezi1] (@w INT) AS BEGIN SELECT '' END (cover sp with BEGIN-END block), But the error did not change. I also add
BEGIN TRY statement and it just got worst.
I'm getting to conclude that creating
TRY_CATCH block is not practical.
Is this even possible to create
TRY_CATCH block? And how?