²ËÄñÇóÖú:@@rowCountÔÚOracle´æ´¢¹ý³ÌµÄÓ÷¨?

ÎÊÌâÃèÊö:
    ÎÒÓÃÒ»¸öÔÚ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