CASE WHEN

[logku]

一个字段 A ，我想要当值为‘’时则替换成当年时间，请问用SQL语句怎么实现？
请各位高手帮帮忙啊．
A
2004
2005
2006
2007
2008
‘’
2004
2005
2006
2007
2008
‘’

[playwarcraft]

update T
set col=case when col='' then year(getdate()) else col end

[子陌红尘]

update tablename set A=rtrim(datepart(yy,getdate())) where A=''

[you_tube]

SELECT CASE WHEN A  ='' THEN  CAST(RTRIM(YEAR(GETDATE())) +'0101' AS DATETIME ) END 

[logku]

不能更新表格啊，会出错的。除了UPDATE 还能用什么

[you_tube]

update T
set col=case when col='' then CAST(RTRIM(YEAR(GETDATE())) +'0101' AS DATETIME ) else col end

[csdyyr]

update tb set A=case when A='' then year(getdate()) else A end

[you_tube]

[Quote=引用 4 楼 logku 的回复:]
不能更新表格啊，会出错的。除了UPDATE 还能用什么
[/Quote]
UPDATE就行

[playwarcraft]

select case when col='' then year(getdate()) else col end as col
from T

[claro]

create table #t  (a varchar(20))
insert into #t select '2004' a union select '2005' union select '2006' union select'2007' union select''
/*

2004
2005
2006
2007
*/
select case when a='' then DATEPART (yy,getdate()) else a end from #t
/*
2009
2004
2005
2006
2007
*/

[htl258_Tony]

update tb set A=year(getdate())
where A='‘’'

[claro]

/*

2004
2005
2006
2007
*/
select case when a='' then DATEPART (yy,getdate()) else a end
from (select '2004' a union select '2005' union select '2006' union select'2007' union select'' )b
/*
2009
2004
2005
2006
2007
*/

[ks_reny]

[Quote=引用 4 楼 logku 的回复:]
不能更新表格啊，会出错的。除了UPDATE 还能用什么
[/Quote]
那就select吧

select 
(case when col='' then year(getdate()) else col end )as col 
From tb