SQL Server Time field bulk increase

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 --search select dateadd(yy,1,dt) dt  from tb --update update tb  set dt = dateadd(yy,1,dt) select *  from tb drop table tb /* dt                                                      ------------------------------------------------------  2007-10-10 00:00:00.000 2007-10-11 00:00:00.000 2007-10-12 00:00:00.000 2007-10-13 00:00:00.000 2007-10-14 00:00:00.000 2007-10-15 00:00:00.000 （所影响的行数为 6 行） */

SQL Server Time field bulk increase