货币_汇率_proc.sql

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

if exists(select name from sysobjects where name='货币_汇率_PROC' and type= 'p')
drop PROC 货币_汇率_PROC
GO 
CREATE PROC 货币_汇率_PROC
@ymo_to Datetime,
@ymo_fr Datetime
AS
CREATE TABLE [#货币汇率] (
	[本位币编码] [varchar] (10) ,
	[外币编码] [varchar] (10) ,
	[年月] [datetime],
	[汇率] [numeric](18, 6) )

INSERT INTO #货币汇率 SELECT* FROM 货币汇率 where 年月 >=@ymo_to and 年月 <=@ymo_fr
SELECT * FROM #货币汇率 where 年月>=@ymo_to and 年月 <=@ymo_fr