update dt_article_attribute_value set end_time = dateadd(mi,30,start_time)
create table tb(dt datetime)insert into tb values(‘2006-10-10‘)insert into tb values(‘2006-10-11‘)insert into tb values(‘2006-10-12‘)insert into tb values(‘2006-10-13‘)insert into tb values(‘2006-10-14‘)insert into tb values(‘2006-10-15‘)go--searchselect dateadd(yy,1,dt) dt from tb--updateupdate tb set dt = dateadd(yy,1,dt)select * from tbdrop table tb/*dt ------------------------------------------------------ 2007-10-10 00:00:00.0002007-10-11 00:00:00.0002007-10-12 00:00:00.0002007-10-13 00:00:00.0002007-10-14 00:00:00.0002007-10-15 00:00:00.000（所影响的行数为 6 行）*/原文：http://www.cnblogs.com/tiancai/p/4609858.html