create table a ([时间] datetime); insert into a select '2013-08-30 17:59:35' union all select '2013-09-01 17:59:35' union all select '2013-09-02 17:59:35' union all select '2013-09-03 18:59:35'
update a set [时间]=dateadd(ss,(rand(checksum(newid()))*60-datepart(ss,[时间])),[时间])