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  發貨地址碼<=@到發碼