货位主文件_proc.sql

来自「SQL-ERP之SQL server 进销存 软件全部存储过程与触发器」· SQL 代码 · 共 18 行

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='货位主文件_PROC' AND TYPE='P')
DROP PROC 货位主文件_PROC
GO
create procedure  货位主文件_PROC
@LOC_to varchar(10),
@LOC_fr varchar(10)
as

CREATE TABLE [#货位主文件] 
(
	[货位编码] [varchar] (10),
	[货位描述] [varchar] (20) ,
	[永久] [char] (1))

insert into #货位主文件 select * from 货位主文件 
where 货位编码>=@LOC_TO AND 货位编码<=@LOC_FR
SELECT* FROM #货位主文件