急问:insert 的sql语句中怎么设一个字段为null值?
我的trigger中需要将对某表A添加的记录组成一个insert字符串,然后记录到一个日志表B中,那么如果添加A的记录中有某个字段为null,那么insert字符串就连不起来了,也为null,该怎么办呢?
CREATE TRIGGER tgA ON A
FOR insert
AS
declare @id varchar(1000),
@lev1Days varchar(1000),
@lev2Days varchar(1000),
@lev3Days varchar(1000),
@WorkTag varchar(200),
@Discrib varchar(200),
@strSql varchar(1000)
select @id =ad.id,@lev1Days=ad.lev1Days , @lev2Days=ad.lev2Days,@lev3Days=ad.lev3Days,@worktag=ad.worktag,@discrib=ad.discrib from A ad ,inserted i where ad.id=i.id
select @strSql = 'insert into A values(' + @id + ',' + @lev1days + ',' + @lev2days + ',' + @lev3days + ',''' + @worktag + ''',''' + @discrib + ''')'
begin
insert into B values (@strSql,getdate())
end