库位代码数据.txt

来自「仓储系统」· 文本 代码 · 共 14 行

select * from StroeRoom
select * from StroePosition
--delete from StroePosition
--sp_help StroePosition
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('01','01','1号库位')
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('01','02','2号库位')
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('02','01','1号库位')
insert into StroePosition(Stroeroom_zip,Stroeplace_zip,Stroeplace_name) values('02','02','2号库位')


insert into Storeposition(Storeroom_zip,Storeplace_zip,Storeplace_name) values('01','01','1号库位')
insert into Storeposition(Storeroom_zip,Storeplace_zip,Storeplace_name) values('01','02','2号库位')
insert into Storeposition(Storeroom_zip,Storeplace_zip,Storeplace_name) values('02','01','1号库位')
insert into Storeposition(Storeroom_zip,Storeplace_zip,Storeplace_name) values('02','02','2号库位')