IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='倉庫主文件_PROC' AND TYPE='P')
DROP PROC 倉庫主文件_PROC
GO
create procedure  倉庫主文件_PROC

as
CREATE TABLE [#倉庫主文件] (
	[倉庫編碼] [varchar] (10),
	[倉庫描述] [varchar] (20),
	[地址] [varchar] (100),
	[聯系人] [varchar] (10),
	[電話] [varchar] (15),
	[傳真] [varchar] (15))
	

insert into #倉庫主文件 select * from 倉庫主文件

SELECT* FROM #倉庫主文件