信用暂停_proc.sql

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

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] NULL )

INSERT INTO #客户主文件 SELECT *FROM 客户主文件
WHERE 客户编码>=@cust_to and 客户编码<=@cust_fr
SELECT *FROM #客户主文件 WHERE 信用暂停='1'
--exec 信用暂停_PROC 'c01','c01'