问题描述:
我用一个在SQLServer写好的存储过程,现在需要把它修改在Oracle中使用,其间它用到@@rowcount,不知道
下面这一段代码该如修改,哪位大虾帮我看一下,谢谢!
SQL code:
[b]SET ROWCOUNT MAXCOUNT[/b]
INSERT INTO SMS_TEMP(SMSID,CONTENT,RESENDTIMES)
SELECT SMSID,'|9997|'+isnull(SMSTYPE,'')+'$'+isnull(DEPARTMENT,'')+'$'+isnull(BUSSNIESSTYPE,'')+'$'+isnull(SUMMITTIME,'')+'$'+isnull(BEGINSETDATE,'')+'$'+isnull(BEGINSETTIME,'')
+'$'+isnull(ENDSETDATE,'')+'$'+isnull(ENDSETTIME,'')+'$'+isnull(BATCHNO,'')+'$|'+isnull(TELEPHONE,'')+'|'+isnull(CONTENT,'')+'|'
+(CASE (SELECT B.BUSI_ID from SMS_TYPE B WHERE A.SMSTYPE = B.ID) WHEN '1' THEN SMSTYPE+BATCHNO ELSE '' END)+'|^',0 from SMS_REQUEST A
WHERE ((CASE ISNULL(BEGINSETDATE,'') WHEN '' THEN DATESTRING ELSE BEGINSETDATE END) <= DATESTRING)
AND ((CASE ISNULL(ENDSETDATE,'') WHEN '' THEN DATESTRING ELSE ENDSETDATE END) >= DATESTRING)
AND ((CASE ISNULL(BEGINSETTIME,'') WHEN '' THEN TIMESTRING ELSE BEGINSETTIME END) <= TIMESTRING)
AND ((CASE ISNULL(ENDSETTIME,'') WHEN '' THEN TIMESTRING ELSE ENDSETTIME END) >= TIMESTRING)
AND (SUBSTR(LTRIM(TELEPHONE), 1, 3) IN (SELECT PREFIX from SMS_PREFIX) OR (SUBSTR(LTRIM(TELEPHONE), 1, 3) = '+86' AND SUBSTR(LTRIM(TELEPHONE), 4, 3) IN (SELECT PREFIX from SMS_PREFIX)))
AND A.TELEPHONE NOT IN (
SELECT C.TELEPHONE from SMS_BLACKLIST C
WHE
大家好,我现在把oracle服务器上面的原始文件,下载到本机了.我想在本机访问数据库怎么设置啊.是不是类似可以建立一个什么虚拟服务器来实现.请大家出出主意
引用
大家好,我现在把oracle服务器上面 ......
