UPDATE a
set a.adddate='2011-11-'
+ CAST(CAST(CEILING(RAND() * 100) AS INT) % 14 + 1 AS VARCHAR(2))
+ ' ' + CAST(CAST(CEILING(RAND() * 100) AS INT) % 24 AS VARCHAR(2))
+ ':' + CAST(CAST(CEILING(RAND() * 100) AS INT) % 60 AS VARCHAR(2))
+ ':' + CAST(CAST(CEILING(RAND() * 100) AS INT) % 60 AS VARCHAR(2))
from _table a
inner join (select TOP 20 * from _table) b ON 本表主键关联
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024