+-+

本系统为企业进存销管理系统

if exists(select name from sysobjects  where name='客户主文件_proc' AND TYPE='P' )
DROP PROC 客户主文件_proc
go
CREATE PROC 客户主文件_proc
@CUST_TO VARCHAR(10),
@CUST_FR VARCHAR(10)
AS
CREATE TABLE [#客户主文件] (
	[客户编码] [varchar] (10),
	[客户描述] [varchar] (50),
	[客户地址] [varchar] (130),
	[城市] [varchar] (10),
	[国家] [varchar] (20),
	[县] [varchar] (20),
	[电话] [varchar] (15),
	[邮编] [varchar] (10),
	[邮箱] [varchar] (30),
	[客户类型] [varchar] (10),
	[信用限额] [numeric](18, 6) DEFAULT (0),
	[账单联系人] [varchar] (10),
	[销售员] [varchar] (10),
	[账单到地址] [varchar] (10),
	[发货到地址] [varchar] (10),
	[银行码] [varchar] (10),
	[货币] [varchar] (10),
	[信用暂停] [char] (1),
	[暂停原因码] [varchar] (10),
	[暂停日期] [datetime] )

INSERT INTO #客户主文件 SELECT *FROM 客户主文件
WHERE 客户编码>=@CUST_TO AND  客户编码<=@CUST_FR