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