仓库主文件_proc.sql

来自「java开发数据库源码,关于仓库系统的数据库,功能齐全,测试成功」· SQL 代码 · 共 19 行

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