Hola, que tal, tengo lo siguiente:
BEGIN TRY
set @GesFchCit1= CONVERT(datetime, @auxfecha,103)
END TRY
BEGIN CATCH
SET @GesFchCit1= @fecha
END CATCH

Y me da errores:
Server: Msg 170, Level 15, State 1, Procedure PromobankFW2, Line 68
Line 68: Incorrect syntax near \'TRY\'.
Server: Msg 170, Level 15, State 1, Procedure PromobankFW2, Line 70
Line 70: Incorrect syntax near \'Catch\'.
Server: Msg 170, Level 15, State 1, Procedure PromobankFW2, Line 72
Line 72: Incorrect syntax near \'TRY\'.

ideas?

Responder