发货地址表_proc.sql

SQL-ERP之SQL server 进销存 软件全部存储过程与触发器

if exists(select name from sysobjects where name='发货地址表_PROC' and type= 'p')
drop PROC 发货地址表_PROC
GO 
CREATE PROC 发货地址表_PROC
@从发码 varchar (10),
@到发码 varchar (10)
AS
CREATE TABLE [#发货地址表] (
	[发货地址码] [varchar] (10) ,
	[发货到码描述] [varchar] (50) ,
	[城市] [varchar] (10) ,
	[省] [varchar] (10) )

INSERT INTO #发货地址表 SELECT* FROM 发货地址表
SELECT *FROM 发货地址表 WHERE 发货地址码>=@从发码 AND  发货地址码<=@到发码