demo014.sql

T-SQL示例大全

/* 文件名称: Demo014.sql */

DECLARE @ErrorNumber int

IF (@@ERROR <> 0)
     SET @ErrorNumber = @@ERROR


IF (@@ERROR <> 0)
     BEGIN
          SET @ErrorNumber = @@ERROR
          PRINT '错误代码是: ' + CAST(@ErrorNumber AS varchar(10))
     END