求句SQL,判断表中每列后并修改该列数据

[zhiweixuexi8]

如我的t表中有 LX int 和 Nane nvarchar(10) 两列

如果LX等于1那么就Name就修改"无",如果LX等于2就修改为"有",请问该怎么样写?要判断此表中所有数据并加以修改...

[王向飞]

update tableTest
set  Nane = case when LX = 1 then '无'   when LX = 2 then '有'
where LX in (1,2) 

[王向飞]

update tableTest
set  Nane = case when LX = 1 then '无'   when LX = 2 then '有' end
where LX in (1,2) 

[heymal]

update tableTest
set Nane = case when LX = 1 then '无' when LX = 2 then '有' end
where LX in (1,2)

[dawugui]

[Quote=引用楼主 zhiweixuexi8 的回复:]
如我的t表中有 LX int 和 Nane nvarchar(10) 两列

如果LX等于1那么就Name就修改"无",如果LX等于2就修改为"有",请问该怎么样写?要判断此表中所有数据并加以修改...
[/Quote]

update t set Name = (case when LX = 1 then '无' when lx = 2 then '有' end)

[dawugui]

update t set Name = (case when LX = 1 then '无' when lx = 2 then '有' end)

update t set Name = (case when LX = 1 then '无' when lx = 2 then '有' else name end)