物料与货位_proc.sql

SQL server 进销存软件数据库设计。大家积极下载

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='物料与货位_PROC' AND TYPE='P')
DROP PROC 物料与货位_PROC
GO
create procedure 物料与货位_PROC
@item_to varchar(30),
@item_fr varchar(30)
as

CREATE TABLE [#物料与货位对照表]
 (
	[仓库编码] [varchar] (10) ,
	[物料编码] [varchar] (30) ,
	[货位编码] [varchar] (10),
	[批号] [varchar] (15)  ,
	[货位等级] [int] ,
	[货位存量] [numeric](18, 5) ,
	[永久货位] [char] (1) )

insert into #物料与货位对照表 select * from 物料与货位对照表
 where 物料编码>=@ITEM_TO AND 物料编码<=@ITEM_FR
SELECT* FROM #物料与货位对照表