付款_供应商_proc.sql

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

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='付款_供应商_PROC' AND TYPE='P')
DROP PROC 付款_供应商_PROC
GO
create  PROC 付款_供应商_PROC
@vend_to varchar(10),
@vend_fr varchar(10)
as
CREATE TABLE [#付款主表]
 (
	[供应商编码] [varchar] (10)  ,
	[银行码] [varchar] (10) ,
	[付款类型] [char] (1) ,
	[支票序号] [int] ,
	[支票号码] [varchar] (10)  ,
	[支票日期] [datetime] ,
	[货币] [varchar] (10)  ,
	[汇率] [numeric](18, 6) ,
	[支票金额] [numeric](18, 6) DEFAULT (0),
	[注释] [text]  ,
	[已分配金额] [numeric](18, 6)  DEFAULT (0.00000),
	[剩余金额] [numeric](18, 6)  DEFAULT (0.00000))

insert into #付款主表 select* from 付款主表
where 供应商编码>=@vend_to and 供应商编码<=@vend_fr

select *from #付款主表