57-trycatch-1.sql

SQL Server 2005基础教程一书的源代码.

DECLARE @Probs int
BEGIN TRY
   SELECT 'This will work'
   SELECT @Probs='Not Right'
   SELECT 10+5,'This will also work, however the error means it wont run'
END TRY
BEGIN CATCH
   SELECT 'An error has occurred at line ' + LTRIM(STR(ERROR_LINE())) +
      ' with error ' + LTRIM(STR(ERROR_NUMBER())) + ' ' + ERROR_MESSAGE()
END CATCH