wander：
UPDATE authors SET state = 'ZZ' FROM (SELECT TOP 10 * FROM thors ORDER BY au_lname) AS t1 ……
[阅读: 655] 2004-07-13 06:36:52
UPDATE authors SET state = 'ZZ' FROM (SELECT TOP 10 * FROM thors ORDER BY au_lname) AS t1 WHERE authors.au_id = t1.au_id
Old soldiers never die, they just fade away .....
| -ICP -IDC -ISP |