year(@date)
year(getdate())
year('20120101')
update table
set column = year(date_column)
whre ....
或者如果您需要在另一个表中
update t
set column = year(t1.date_column)
from table_source t1
join table_target t on (join condition)
where ....
如何从SQL Server 2008中的日期中仅提取年份?
year(@date)
year(getdate())
year('20120101')
update table
set column = year(date_column)
whre ....
或者如果您需要在另一个表中
update t
set column = year(t1.date_column)
from table_source t1
join table_target t on (join condition)
where ....