CREATE TRIGGER [AddGoods_Update] ON [dbo].[AddGoods]
FOR UPDATE
AS
Begin TransAction
If Update( GoodsCode )
Begin
RaisError ( '请删掉这笔记录,重新做一个!',16,1 )
RollBack TransAction
End
commit TransAction
go
要不这样试试,我也不清楚
CREATE TRIGGER [AddGoods_Update] ON [dbo].[AddGoods]
FOR UPDATE
AS
Begin TransAction
If Update( GoodsCode )
Begin
RaisError ( '请删掉这笔记录,重新做一个!',16,1 )
RollBack TransAction
End