付款明细_proc.sql

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

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='付款明细_PROC' AND TYPE='P')
DROP PROC 付款明细_PROC
GO
create  PROC 付款明细_PROC
@vou_to int,
@vou_fr int
as
CREATE TABLE [#付款明细表] (
	[供应商编码] [varchar] (10)  ,
	[凭证号] [int] NULL ,
	[支票号码] [varchar] (10) ,
	[货币] [varchar] (10)  ,
	[汇率] [numeric](18, 6) ,
	[应付金额] [numeric](18, 6),
	[实付金额] [numeric](18, 6) )
	
insert into #付款明细表 select* from 付款明细表
where 凭证号>=@vou_to and 凭证号<=@vou_fr
select *from #付款明细表