仓库主文件_proc.sql

SQL server 进销存软件数据库设计。大家积极下载

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 #仓库主文件