Oracel 的start with 怎样转换成SQL Server 的sql语句,如下:
SELECT A.FOLDERNO,B.TITLE,B.PRINTHINAGATA,B.MAILHINAGATA,B.AUTHOR,LSTEDITTIME,B.DISPSEQ FROM (SELECT FOLDERNO FROM CVM_KAITOUHINAFLD START WITH FOLDERNO=2361 CONNECT BY PRIOR FOLDERNO=PARFOLDERNO ORDER BY DISPSEQ) A,CVM_KAITOUHINADOC B WHERE A.FOLDERNO=B.FOLDER
谢谢.
SELECT A.FOLDERNO,B.TITLE,B.PRINTHINAGATA,B.MAILHINAGATA,B.AUTHOR,LSTEDITTIME,B.DISPSEQ FROM (SELECT FOLDERNO FROM CVM_KAITOUHINAFLD START WITH FOLDERNO=2361 CONNECT BY PRIOR FOLDERNO=PARFOLDERNO ORDER BY DISPSEQ) A,CVM_KAITOUHINADOC B WHERE A.FOLDERNO=B.FOLDER
谢谢.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货