关于oracle转换sql server的问题
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';
Cursor Cu_BY_USER_ADD Is
Select a.TrueTel,a.VirtualTel
From T_SERVICEOP a
Where a.OpType=2
And TO_CHAR(a.OpDate,'YYYYMMDD')=TO_CHAR(SYSDATE-1,'YYYYMMDD')
And TO_CHAR(a.OpDate,'DD')>='01'
And TO_CHAR(a.OpDate,'DD')<='24'
And TO_CHAR(SYSDATE, 'DD')>='02'
And TO_CHAR(SYSDATE, 'DD')<='25';