各位高手,如下例子是在Oracle中写的,需要用SQL server改写,该如何改写呢?小弟刚接触数据库,实在不太明白
CREATE OR REPLACE PACKAGE BODY KMDW.Map_T_Rpt_For_Ccy_Rate
AS
PROCEDURE INSERT_RECORD (p_sym_run_date IN DATE)
IS
CURSOR c_key IS
SELECT internal_key,branch,ccy,tran_amt AS amt,tran_date
FROM STA_RB_TRAN_HIST v_term VARCHAR2(4); FOR i_key IN c_key LOOP
SELECT MAX(effect_date)
INTO v_effect_date
FROM STA_FM_INT_RATE
WHERE int_type=v_int_type
AND ccy=i_key.ccy
END LOOP
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货