Update trigger condition, please help me...

Question

Hello,team.
If I want to update columns, when my number of SP_SW is less than 30, add SP_SW as 50, how can I go about implementing it, please help me, it's urgent for me....
Thanks.
My code:CREATE TRIGGER trigger
ON SP_SW
AFTER INSERT
AS
update SP_SW
set SP_SW=id
from inserted
where inserted.id=id

Answer 1

Hi @SPWGUT
How about this:

update SP_SW  
set SP_SW=case when SP_SW <30 then 50 else id end  
from inserted  
where inserted.id=id  

Best regards,
LiHong

Answer 2

Can it be written like this where inserted.id=id and SP_SW<30,Help me...