笔记5 T-SQL技巧case when then end的update语句

笔记5 T-SQL技巧case when then end的update语句

--T-SQL技巧case when then end的update语句
declare @T table (name varchar(1),taici int)
insert into @T
select 'a',1 union all
select 'b',2 union all
select 'c',3 union all
select 'd',4 union all
select 'e',5

SELECT * FROM @T

update @T set taici=
case when taici=5 then 2
when taici<2 then taici
when taici>=2 then taici+1
when taici=2 then 5 end

select * from @T order by taici
/*
name taici
---- -----------
a    1
e    2
b    3
c    4
d    5
*/