李颖: SQL Server可以用update from语句 [阅读: 1050] 2004-07-13 05:33:44 别的数据库可以用 UPDATE TAB1 SET NAME = (SELECT NAME FROM TAB2 WHERE TAB2.ID = TAB1.ID) DISSENT IS THE HIGHEST FORM OF PATRIOTISM ! --Thomas Jefferson