一个触发器问题请大家帮忙修改!很着急
CREATE TRIGGER [trig_omsYunDanJian_Insert]
ON [dbo].[omsYunDanJian]
AFTER INSERT
AS
--声明变量
Declare @m_zhongliang decimal(7,2)
declare @m_tiji decimal(15,6)
BEGIN
SET NOCOUNT ON;
@m_zhongliang = select 'ZL '=SUM(ZhongLiang)
from omsYunDanJian
where omsYunDanJian.YunDanID=inserted.YunDanID
@m_tiji= select 'TJ '=SUM(TiJi)
from omsYunDanJian
where omsYunDanJian.YunDanID=inserted.YunDanID
if(@m_zhongliang > 0 || @m_tiji > 0)
UPDATE omsYunDan
SET
ZhongLiang = @m_zhongliang ,
TiJi=@m_tiji=
from inserted
WHERE omsYunDan.YunDanID = inserted.YunDanID
SET NOCOUNT OFF
END
请大家帮我修改一下这个触发器!
[解决办法]
差不多这样吧
CREATE TRIGGER [trig_omsYunDanJian_Insert]
ON [dbo].[omsYunDanJian]
AFTER INSERT
AS
--声明变量
Declare @m_zhongliang decimal(7,2)
declare @m_tiji decimal(15,6)
BEGIN
SET NOCOUNT ON
select @m_zhongliang = SUM(ZhongLiang) as 'ZL ', @m_tiji = SUM(TiJi) as 'TJ '
from omsYunDanJian
where omsYunDanJian.YunDanID=inserted.YunDanID
if(@m_zhongliang > 0 || @m_tiji > 0)
UPDATE omsYunDan
SET ZhongLiang = @m_zhongliang , TiJi = @m_tiji
from omsYunDan inner join inserted
on omsYunDan.YunDanID = inserted.YunDanID
SET NOCOUNT OFF
END
[解决办法]
select @m_zhongliang = SUM(ZhongLiang) as 'ZL ', @m_tiji = SUM(TiJi) as 'TJ '
=============================================================================
select 用法有错；
SELECT @var1 = 'Generic Name '
SELECT @var1 AS 'Company Name '
不能 SELECT @m_zhongliang = SUM(ZhongLiang) AS 'ZL '
[解决办法]
select @m_zhongliang = SUM(ZhongLiang), @m_tiji = SUM(TiJi)
from omsYunDanJian inner join inserted
on omsYunDanJian.YunDanID=inserted.YunDanID
