（5）批量更新

1、SQLServer

UPDATE BASE_STUDENT 
   SET CLASS    = T.CLASS, 
       PHONE    = T.PHONE 
FROM BASE_STUDENT P, #TEMP_STUDENT T 
	   WHERE P.ID = T.ID

2、Oracle

UPDATE BASE_STUDENT A
   SET (A.CLASS, A.PHONE, A.REMARK) =
       (SELECT B.CLASS, B.PHONE, B.REMARK FROM TEMP_STUDENT B WHERE A.ID = B.ID)
 WHERE EXISTS (SELECT 1 FROM TEMP_STUDENT C WHERE C.ID = A.ID)