errmsgdemo4.sql

T-SQL示例大全

/* 文件名称: ErrMsgDemo4.sql */
USE 北风贸易
if exists (select * from dbo.sysobjects where id = object_id(N'MyTable') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table MyTable
GO

SELECT * INTO MyTable FROM 章立民工作室

ALTER TABLE dbo.MyTable WITH NOCHECK ADD 
	CONSTRAINT CK_MyTable_目前薪资 CHECK (目前薪资 >= 10000 and 目前薪资 <= 200000)
GO

BEGIN TRANSACTION

  UPDATE MyTable
      SET 目前薪资 = 目前薪资 - 10000
  
IF @@ERROR = 547
    PRINT '违反了某一个 CHECK 条件约束'

IF @@ROWCOUNT = 0 
    PRINT '没有任何数据记录被更新'
ELSE
    PRINT STR(@@ROWCOUNT) + ' 个数据记录被更新'

COMMIT TRANSACTION