比如说
select c.partnum,c.revision,b.coreThick Into #IssCoreThick from STdMatPressdtl a join MatPress b on b.partname='004' and a.matcode=b.matcode Update aSet a.Thickness=b.coreThickFrom #ProdHoleNum a Join #IssCoreThick b on a.partnum=b.partnum where a.IssLayer=1 Drop Table #IssCoreThick 存储过程中很多这样的,有什么好的解决办法啊?谢谢OracleSQL Server存储
select c.partnum,c.revision,b.coreThick Into #IssCoreThick from STdMatPressdtl a join MatPress b on b.partname='004' and a.matcode=b.matcode Update aSet a.Thickness=b.coreThickFrom #ProdHoleNum a Join #IssCoreThick b on a.partnum=b.partnum where a.IssLayer=1 Drop Table #IssCoreThick 存储过程中很多这样的,有什么好的解决办法啊?谢谢OracleSQL Server存储
2.修改sql.
insert Into #IssCoreThick
select c.partnum,c.revision,b.coreThick from STdMatPressdtl a join MatPress b on b.partname='004' and a.matcode=b.matcode