SQL 的一些批量插入和修改
时间：2010-10-31 来源：BigRain
Insert into Table2(a,b, c, d) select a,a*c,c,5 from Table1
update t1
set t1.c2 = t2.c2
from t2
where t1.c1 = t2.c1
相关阅读 更多 +
时间：2010-10-31 来源：BigRain
Insert into Table2(a,b, c, d) select a,a*c,c,5 from Table1
update t1
set t1.c2 = t2.c2
from t2
where t1.c1 = t2.c1
