首页 > 数据库技术 > 详细

Windchill中间表相关操作sql语句

时间:2016-03-18 10:49:00      阅读:716      评论:0      收藏:0      [点我收藏+]

通过父料与子键查询

select * from SAP_Bom where sap_panterPartNubmer=  ‘3072490029‘ and sap_childPartNumber = ‘3063004642‘

更新版本

update SAP_Bom set sap_childPartVersion = ‘2‘ where sap_panterPartNubmer=‘ 2010301470‘ and sap_childPartNumber = ‘ 2061003002‘ 

插入数据

insert into SAP_Bom(sap_panterPartNubmer,sap_panterPartVesion,sap_childPartNumber
,sap_childPartVersion,sap_quantity,sap_unit,sap_cCreateUser,sap_dCreateDate,sap_childPartAlternateNumber)values(‘3010700380‘,‘1‘,‘3072200056‘,‘1‘,‘1.0‘,‘PCS‘,‘zhuokailong‘,GETDATE(),‘‘) 

复制插入

insert into SAP_Bom(sap_revlv,sap_panterPartNubmer,sap_panterPartVesion,sap_childPartNumber,
sap_childPartVersion,sap_childPartAlternateNumber,sap_quantity,sap_unit,sap_mes,sap_BomRemark1,sap_BomRemark2,
sap_BomRemark3,sap_BomRemark4,sap_BomRemark5,sap_BomRemark6,sap_BomRemark7,sap_BomRemark8,sap_BomRemark9,
sap_cCreateUser,sap_dCreateDate)
select sap_revlv,‘3010601290‘,sap_panterPartVesion,sap_childPartNumber,
sap_childPartVersion,sap_childPartAlternateNumber,sap_quantity,sap_unit,sap_mes,sap_BomRemark1,sap_BomRemark2,
sap_BomRemark3,sap_BomRemark4,sap_BomRemark5,sap_BomRemark6,sap_BomRemark7,sap_BomRemark8,sap_BomRemark9,
sap_cCreateUser,GETDATE() from dbo.SAP_Bom where sap_id=‘394201‘

 

Windchill中间表相关操作sql语句

原文:http://www.cnblogs.com/Jaydenzzz/p/5290999.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!