Error handling in SQL SERVER (try Catch) _ Database other

BEGIN TRY
......
End TRY
BEGIN CATCH
......
End CATCH.
In addition, the WITH statement, if there are other SQL statements before it, should be preceded by the end of the SQL statement with a semicolon ";". For example, in this try catch, you should add a ";" in the front, as follows:
BEGIN TRY

With W as (
SELECT F1,F2,F3
, Row_number () over (order by Id DESC) as ROW
from [T1]
WHERE code= @Code
)
INSERT into [T2] (
F1,f2,f3
SELECT F1,F2,F3
From W WHERE row>100;
End TRY
BEGIN CATCH
End CATCH;