UPDATE a SET btdate = '2013-6-6 0:00:00' from jb_xs a join (select top 10 * from jb_xs order by newid()) b on a.id=b.id --id为主键
放到 jb_xs 表里查询时候 验证sql语法 先提示验证通过 随后提示无法更新 btdate `然后 语法变成· ··········· UPDATE a SET a.btdate = '2013-6-6 0:00:00' FROM jb_xs AS a INNER JOIN (SELECT TOP (10) id, username, btname, btcontent, btdate, sh, btclass, hit, shyy, sex, area_b, area_s FROM jb_xs ORDER BY NEWID()) AS b ON a.id = b.id CROSS JOIN a
from jb_xs a
join (select top 10 * from jb_xs order by newid()) b
on a.id=b.id --id为主键
···········
UPDATE a
SET a.btdate = '2013-6-6 0:00:00'
FROM jb_xs AS a INNER JOIN
(SELECT TOP (10) id, username, btname, btcontent, btdate, sh, btclass, hit, shyy, sex, area_b, area_s
FROM jb_xs
ORDER BY NEWID()) AS b ON a.id = b.id CROSS JOIN
a