migration_po_number_list.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

select * from Order_Number
select * from LhMacao_Order_Number
select * from Longhua_Order_Number
select * from macao_Order_Number




update po_order_number
	set number = b.number,
	   last_number = b.last_number 
from po_order_number a, order_number b
where a.iden = b.iden 

go

update po_order_number
	set number = b.number,
	   last_number = b.last_number 
from po_order_number a, LhMacao_Order_Number b
where a.iden = 'POML' and b.iden ='ML' 
go

update po_order_number
	set number = b.number,
	   last_number = b.last_number 
from po_order_number a, Longhua_Order_Number b
where a.iden = 'POL' and b.iden ='L' 

go

update po_order_number
	set number = b.number,
	   last_number = b.last_number 
from po_order_number a, macao_Order_Number b
where a.iden = 'POM' and b.iden ='M' 
go

select * From po_order_number

select * from Order_Number
select * from LhMacao_Order_Number
select * from Longhua_Order_Number
select * from macao_Order_Number