如何在触发器中给新字段赋值

[makelzw]

在操作添加新记录的时候，某些字段的值想在触发器中实现，该如何实现？

[makelzw]

有人回答吗

[daijingjie2002]

update 表 set 子端=‘’where id in (select id from inserted where 条件)

[xluzhong]

create trigger test
on tablename
for insert
as
update tablename
set 字段=值
--where 条件
go

[makelzw]

大家看下我写的是否正确：
CREATE TRIGGER tr_cw_zl_insert ON [dbo].[CW_ZL]
FOR INSERT
AS
BEGIN
DECLARE @bm varchar(16)
DECLARE @prior_bm varchar(16)
DECLARE @mc varchar(100)
DECLARE @qc varchar(200)
DECLARE @jc int
DECLARE @cd int
SELECT @bm = bm,@mc = mc,@qc = qc,@jc = jc FROM inserted
IF @qc is null
UPDATE cw_zl SET qc = @mc WHERE bm = @bm
ELSE
BEGIN
SET @jc = @jc - 1
SET @cd = dbo.f_cw_xmcd(@dm,'01',@jc)
SET @prior_bm = substring(@bm,1,@cd)
SELECT @qc = qc FROM cw_zl WHERE bm = @bm
SET @qc = @qc + '/' + @mc
UPDATE cw_zl SET qc = @qc WHERE bm = @prior_bm
END
END