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 GO
after BEGIN TRY
statement and it just got worst.
I'm getting to conclude that creating sp
inside TRY_CATCH
block is not practical.
Is this even possible to create sp
inside TRY_CATCH
block? And how?