注册账号 登录
用友之家-用友软件论坛 返回首页

用友软件007的个人空间 https://www.oyonyou.com/?265061 [收藏] [复制] [分享] [RSS]

日志

分享 用友通整理现存量sql语句
2013-7-5 14:35
if exists (select * from tempdb..sysobjects where type='u' and name='forcurrentsyz') drop table tempdb..forcurrentsyz go select cwhcode,cinvcode,sum(iquantity) as iquantity into tempdb..forcurrentsyz from ( select cwhcode,cinvcode,iaInquantity as iquantity from ia_subsidiary where cvoutype='3 ...
471 次阅读|0 个评论

QQ|站长微信|Archiver|手机版|小黑屋|用友之家 ( 蜀ICP备07505338号|51072502110008 )

GMT+8, 2024-5-14 15:32 , Processed in 0.019052 second(s), 10 queries , Gzip On, Redis On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

返回顶部