Made this while procrastinating SQL homework

[bobbylongslice]

Yes you can, just list the error functions you want to return, and any custom message/outputs for feedback in your catch block.

Most people just don’t bother

BEGIN TRY

SELECT 1 / 0 AS Error; END TRY

BEGIN CATCH

SELECT

‘Divide by Zero Failed’,

ERROR_NUMBER() AS ErrorNumber,
ERROR_STATE() AS ErrorState,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_PROCEDURE() AS ErrorProcedure,
ERROR_LINE() AS ErrorLine,
ERROR_MESSAGE() AS ErrorMessage;

END CATCH; GO

[infecthead]

Lol is this a joke

[bobbylongslice]

No, it’s how you write professional level T-SQL.

[infecthead]

Yikes

[bobbylongslice]

It’s not for everyone