Windchill中间表相关操作sql语句

通过父料与子键查询

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'