如何批量修改数据？

SQL code

SELECT  dbo.cj.cjid, dbo.xs.xsid AS xsxsid, dbo.xs.xuehao, dbo.cj.xsidFROM  dbo.xs INNER JOINdbo.cj ON dbo.xs.xuehao = dbo.cj.xuehao

如何update cj set cj.xsid=xs.xsid

[解决办法]

SQL code

update dbo.cj set dbo.cj.xsid=xs.xsidfrom dbo.xswhere dbo.xs.xuehao = dbo.cj.xuehao
[解决办法]
update cj set cj.xsid=xs.xsid
FROM  dbo.xs INNER JOIN
dbo.cj ON dbo.xs.xuehao = dbo.cj.xuehao


[解决办法]
探讨

2楼和1楼有何区别？