migration_order_number.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 25 行

select * from order_number
select * from longhua_order_number
select * from macao_order_number
select * from po_order_number

/*

update po_order_number
	set number = 8519
	   last_number = 'PO04-08519'
WHERE iden = 'PO'


update po_order_number
	set number = 113
	   last_number = 'POL04-00113
WHERE iden = 'POL'


update po_order_number
	set number = 1042
	   last_number = 'POM04-01042
WHERE iden = 'POM'

*/