一个触发器问题请大家帮忙修改!很着急
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