供应商主文件_proc.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 34 行

if exists(select name from sysobjects  where name='供应商主文件_proc' AND TYPE='P' )
DROP PROC 供应商主文件_proc
go
CREATE PROC 供应商主文件_proc
@VEND_TO VARCHAR(10),
@VEND_FT VARCHAR(10)
AS

 CREATE TABLE [#供应商主文件] (
	[供应商编码] [varchar] (10),
	[供应商描述] [varchar] (50),
	[供应商地址] [varchar] (130),
	[城市] [varchar] (10),
	[国家] [varchar] (20),
	[县] [varchar] (20),
	[邮编] [varchar] (20),
	[邮箱] [varchar] (30),
	[类型] [varchar] (20),
	[仓库] [varchar] (10),
	[发货途径] [varchar] (10),
	[采购员] [varchar] (10),
	[银行码] [varchar] (10),
	[货币] [varchar] (10),
	[账单到地址] [varchar] (10),
	[账单联系人] [varchar] (10),
	[税码] [varchar] (10),
	[付款暂停] [char] (1),
	[暂停原因码] [varchar] (10),
	[暂停付款日期] [datetime])

INSERT INTO #供应商主文件 SELECT *FROM 供应商主文件
WHERE 供应商编码>=@VEND_TO AND 供应商编码<=@VEND_TO
SELECT *FROM #供应商主文件