SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRGSalOrder' AND type = 'TR')
DROP TRIGGER TRGSalOrder
GO
create TRIGGER TRGSalOrder
ON TF_POS
FOR INSERT, UPDATE
AS
DECLARE @Order_QTY int,@QTY int,
@sWH varchar(20)
select @sWH=WH from INSERTED
select @QTY=QTY from INSERTEDSELECT @Order_QTY = sum(t.QTY) FROM MF_POS m join TF_POS t on m.OS_ID=t.OS_ID and m.OS_NO=t.OS_NO
where m.USR='0001'
set @Order_QTY=@Order_QTY+@QTYIF (@sWH = '0000')
BEGIN
RAISERROR ('库位不能为0000.', 16, 1)
ROLLBACK TRANSACTION
END
else
IF (@Order_QTY > 1000)
BEGIN
RAISERROR ('订单数量不能大于1000.', 16, 1)
ROLLBACK TRANSACTION
ENDGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO为什么打开TRIGGER 看不到这段代码呢?老大非要我重写?编辑就看不到下面的代码?我晕了!
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRGSalOrder' AND type = 'TR')
DROP TRIGGER TRGSalOrder
GO
SET ANSI_NULLS ON
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRGSalOrder' AND type = 'TR')
DROP TRIGGER TRGSalOrder
GO
create TRIGGER TRGSalOrder
ON TF_POS
FOR INSERT, UPDATE
AS
DECLARE @Order_QTY int,@QTY int,
@sWH varchar(20)
select @sWH=WH from INSERTED
select @QTY=QTY from INSERTEDSELECT @Order_QTY = sum(t.QTY) FROM MF_POS m join TF_POS t on m.OS_ID=t.OS_ID and m.OS_NO=t.OS_NO
where m.USR='0001'
set @Order_QTY=@Order_QTY+@QTYIF (@sWH = '0000')
BEGIN
RAISERROR ('库位不能为0000.', 16, 1)
ROLLBACK TRANSACTION
END
else
IF (@Order_QTY > 1000)
BEGIN
RAISERROR ('订单数量不能大于1000.', 16, 1)
ROLLBACK TRANSACTION
ENDGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO为什么打开TRIGGER 看不到这段代码呢?老大非要我重写?编辑就看不到下面的代码?我晕了!
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRGSalOrder' AND type = 'TR')
DROP TRIGGER TRGSalOrder
你把它
生成sql指令代碼就可以看見了
WHERE name = 'TRGSalOrder' AND type = 'TR')
DROP TRIGGER TRGSalOrder
上面那段代码的意识就是
在你新建触发器之前
如果你已经有 TRGSslOrder这个触发器
就删除这个触发器
WHERE name = 'TRGSalOrder' AND type = 'TR')
DROP TRIGGER TRGSalOrder) 代码就不见了
你前面写的IF EXISTS ....这是不会保存在TRIGGER只中的
你可以把整个语句保存在脚本里