哈哈,在这个库里终于被我看到了二转代码,马上去试下,看行不行- 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
复制代码 |