create trigger tr_Level
on QQlevel
for insert,update
as
begin
update QQlevel
set QQLevel =(
case
when QQTime>0 and QQTime<=20 then 1
when QQTime>20 and QQTime<=50 then 2
when QQTime>50 and QQTime<=100 then 3
when QQTime>100 and QQTime<=200 then 4
end
)
end
Go
on QQlevel
for insert,update
as
begin
update QQlevel
set QQLevel =(
case
when QQTime>0 and QQTime<=20 then 1
when QQTime>20 and QQTime<=50 then 2
when QQTime>50 and QQTime<=100 then 3
when QQTime>100 and QQTime<=200 then 4
end
)
end
Go
(
QQNumber varchar(20),
QQUser varchar(10),
QQTime varchar(6),
QQLevel int
)
Go
insert into QQlevel(QQNumber,QQUser,QQTime) values ('154538878','kangfu','2218')
select * from QQlevelcreate trigger tr_Level
on QQlevel
for insert,update
as
begin
select QQLevel =
case QQTime
when 0<QQTime<20 then
insert into QQlevel(QQLevel) values (1)
when 20<QQTime<=50 then
insert into QQlevel(QQLevel) values (2)
when 50<QQTime<=100 then
insert into QQlevel(QQLevel) values (3)
when 100<QQTime<=200 then
insert into QQlevel(QQLevel) values (4)
end,
from inserted
end
Go
create trigger tr_Level
on QQlevel
for insert,update
as
begin
update QQlevel set QQLevel =
case QQTime
when 0<QQTime<20 then
insert into QQlevel(QQLevel) values (1)
when 20<QQTime<=50 then
insert into QQlevel(QQLevel) values (2)
when 50<QQTime<=100 then
insert into QQlevel(QQLevel) values (3)
when 100<QQTime<=200 then
insert into QQlevel(QQLevel) values (4)
end,
from QQlevel a,inserted b where a.QQNumber=b.QQNumber
end
Go
on QQlevel for insert,update
as
begin
update QQlevel
set [QQLevel]=(case when 0<QQTime<20 then 1
when 20<QQTime<=50 then 2
when 50<QQTime<=100 then 3
when 100<QQTime<=200 then 4
end)
from QQLevel a join inserted i
on a.QQNumber=i.QQNumber
end
Go