从Oracle到MS SQL [英] Oracle to MS SQL

问题描述

亲爱的所有人，

我在oracle中编写了此查询.如何在MSSQL中编写此代码?

Dear all,

I wrote this query in oracle. How can I write this in MSSQL?

SELECT I.NBRANCH_SL,I.NCM_SL,I.NSIDE_SL,I.CSIDE_SL,RTA.NRATE_SQ_FT,RTA.NRATE_WST_SQ_FT  ,I.CPRINT_SIDE_SL
 FROM PR_MT_PRINT_FLX_RATE RTA,
 (   SELECT RFPS.NORDER NORD_PS,RFPD.NORDER NORD_PD,RFPS.NBRANCH_SL,RFPS.NCM_SL,RFPS.CNAME CPRINT_SIDE_SL,RFPD.NCM_SL NSIDE_SL,RFPD.CNAME CSIDE_SL
  FROM CM_MT_REF_CODE RFPS,CM_MT_REF_CODE RFPD    WHERE RFPS.NREF_ID = 2   AND RFPD.NREF_ID = 6   ) I
  WHERE I.NBRANCH_SL = RTA.NBRANCH_SL(+)
   AND I.NCM_SL = RTA.NCM_PAP_QLT_SL(+)
   AND I.NSIDE_SL = RTA.NSIDE_SL(+)
   AND RTA.NMACHINE_SL(+) = 265
   ORDER BY I.CPRINT_SIDE_SL,I.CSIDE_SL

推荐答案

AFAIK，在Oracle中(+)"不存在任何内容，而在SQL中保留的查询应该相同.我没有在此处使用任何Oracle特定的关键字.

AFAIK, ''(+)'' is nothing in Oracle and the query leaving that should be the same in SQL. I don''t see any Oracle specific keyword used here.

ys..buddy ..我得到了答案..yo..yo ..

ys..buddy.. i got the answer..yo..yo..

SELECT I.NBRANCH_SL,I.NCM_SL,I.NSIDE_SL,I.CSIDE_SL,RTA.NRATE_SQ_FT,RTA.NRATE_WST_SQ_FT  ,I.CPRINT_SIDE_SL
 FROM
 ( SELECT RFPS.NORDER NORD_PS,RFPD.NORDER NORD_PD,RFPS.NBRANCH_SL,RFPS.NCM_SL,RFPS.CNAME CPRINT_SIDE_SL,RFPD.NCM_SL NSIDE_SL,RFPD.CNAME CSIDE_SL
  FROM CM_MT_REF_CODE RFPS,CM_MT_REF_CODE RFPD    WHERE RFPS.NREF_ID = 2   AND RFPD.NREF_ID = 6  )
 I
left outer join  PR_MT_PRINT_FLX_RATE AS RTA on
(I.NBRANCH_SL = RTA.NBRANCH_SL
and I.NCM_SL = RTA.NCM_PAP_QLT_SL
and I.NSIDE_SL = RTA.NSIDE_SL)
and RTA.NMACHINE_SL = 265
ORDER BY I.CPRINT_SIDE_SL,I.CSIDE_SL

这篇关于从Oracle到MS SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！