| 哈哈,在这个库里终于被我看到了二转代码,马上去试下,看行不行 复制代码DECLARE @class char(21)
set @class = (select class from userdata where struserid = @id)
if @class = 105
begin
update userdata set class = 106 where struserid = @id
end
if @class = 107
begin
update userdata set class = 108 where struserid = @id 
end
if @class = 109
begin
update userdata set class = 110 where struserid = @id 
end
if @class = 111
begin
update userdata set class = 112 where struserid = @id 
end
if @class = 205
begin
update userdata set class = 206 where struserid = @id 
end
if @class = 207
begin
update userdata set class = 208 where struserid = @id 
end
if @class = 209
begin
update userdata set class = 210 where struserid = @id 
end
if @class = 211
begin
update userdata set class = 212 where struserid = @id 
end
 |