物料与仓库_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] (30),
	[仓库编码] [varchar] (10),
	[安全库存量] [numeric](18, 6),
	[上次盘点时间] [datetime])

insert into #物料与仓库 select * from 物料与仓库  where 物料编码>=@ITEM_TO AND 物料编码<=@ITEM_FR
SELECT* FROM #物料与仓库