怎么把oracle改成sql server ?
CREATE OR REPLACE Procedure PROC_INPUT_BYFEE
IS
l_sTrueTel T_TRUETEL.TrueTel%Type;
l_sVirtualTel T_VIRTUALTEL.VirtualTel%Type;
l_sServiceType T_SGIP_MS.ServiceType%Type;
l_iCount int
l_iExist int --当前处于注册状态的用户(只在1号运行)
Cursor Cu_BY_USER_NOW Is
Select a.TrueTel,a.VirtualTel
From T_VIRTUALTEL a
Where a.ActiveFlag=1
AND TO_CHAR(SYSDATE, 'DD')='01';
帮帮忙!!!谢谢了!
CREATE OR REPLACE Procedure PROC_INPUT_BYFEE
IS
l_sTrueTel T_TRUETEL.TrueTel%Type;
l_sVirtualTel T_VIRTUALTEL.VirtualTel%Type;
l_sServiceType T_SGIP_MS.ServiceType%Type;
l_iCount int
l_iExist int --当前处于注册状态的用户(只在1号运行)
Cursor Cu_BY_USER_NOW Is
Select a.TrueTel,a.VirtualTel
From T_VIRTUALTEL a
Where a.ActiveFlag=1
AND TO_CHAR(SYSDATE, 'DD')='01';
帮帮忙!!!谢谢了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货