好急好急，这个存储过程处理有错，帮忙解决！！！高分送出！解决加分！

[ylljony]

CREATE TRIGGER [TRIGGER NAME] ON [callpolicer_Temp]
FOR INSERT
AS

update callpolicer_Temp set age=callpolicer_Temp.age+'岁' where callpolicer_Temp.age<>null --or callpolicer_Temp.age<>""

在临时表的所有age字段值插入后此字段值后加岁

[ylljony]

本来age 字段值是一个数字形式的如‘３５’,我的目的是在插入后所有的age 字段值后加一个“岁”.

[ylljony]

对不起，写错了。是触发器的问题。本人好急请高手们帮忙解决。

[foolishtiger]

大哥,这个是触发器啊,存储过程在哪?

[ylljony]

就是说触发器啊！我已经更正过了！

[xmao]

CREATE TRIGGER tr_age111 ON agetest
FOR INSERT
AS

update agetest set age=age+'岁' where age<>''

我试了，可以。。用单引号

[ylljony]

好急用的怎么没人回答呢

[ylljony]

我触发器是这样写的
CREATE TRIGGER change_age_tig ON dbo.callpolicer_Temp
FOR INSERT
AS
update callpolicer_Temp set age=callpolicer_Temp.age+'岁'
where callpolicer_Temp.age is not null or callpolicer_Temp.age<>''

错误结果是插入了三个“岁”如：“25岁岁岁”“35岁岁岁”

[cuiyxy]

将age<>null改为 Not (age is null)

CREATE TRIGGER [YourTriggerName] ON [callpolicer_Temp]
FOR INSERT
AS

update callpolicer_Temp set age=age+'岁' where (not (age is null))
and age<>''

[ylljony]

结账已解决

[cuiyxy]

是不是加了条件 (right(callpolicer_Temp.age,1)<>'岁')？