INSERT ... SELECT INSERT INTO #TABLE1(AAA,BBB,CCC) SELECT AAA,BBB,CCC FROM #TABLE2 UPDATE .... FROM UPDATE #TABLE1 SET AAA=B.AAA FROM #TABLE1 A, #TABLE2 B WHERE A.IDX=B.IDX AND B.BBB='' UPDATE #TABLE1 SET VALUE=TEMPTB.NDATE FROM (SELECT getdate() AS NDATE) AS TEMPTB) UPDATE ... TOP UPDATE #TABLE1 SET STATE = '00' FROM (SELECT TOP 10 au_id FROM #TABLE1 ORDER BY au_name) AS X WHERE #TABLE1.au_id =..