wander · 2004-07-13 06:36:52 · 阅读: 707 UPDATE authors SET state = 'ZZ' FROM (SELECT TOP 10 * FROM thors ORDER BY au_lname) AS t1 …… UPDATE authors SET state = 'ZZ' FROM (SELECT TOP 10 * FROM thors ORDER BY au_lname) AS t1 WHERE authors.au_id = t1.au_id