一条access 里的语句，麻烦帮我改写成 ms sqlserver 里面的语句

2011-02-21 07:05:01 156 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

ASP网站ACCESS数据库转MS SQL以及远程连接MS SQL数据库的经验自己的一个网站，之前一直使用ASP+ACCESS的组合。但access数据库的不足和弊端是显而易见的。近期，随着网站规模的扩大，对数据库的要求提高了，打算用MS SQL替换ACCESS数据库，上网查了一下，虽然有点小繁琐，但总体不是很难。于是决定实施，大致经历了本地个人电脑安装SQL Server 2008、用第三方工具转换ACCESS为MSSQL、ASP网站程序代码修改和本地调试、本地MSSQL... 阅读详情

语句如下：
SELECT Ay_Content.*, Ay_Class.bName AS bClassName, Ay_Class.bParent AS bParentID, IIf(IsNull(c.bCommentCount),0,c.bCommentCount) AS bCommentCount
FROM (Ay_Content LEFT JOIN Ay_Class ON Ay_Content.bClassID = Ay_Class.bId) LEFT JOIN [select bArtID,count(*) as bCommentCount from Ay_Comment group by bArtID]. AS c ON Ay_Content.bId = c.bArtID;

access 下的，麻烦帮我改写成ms sqlserver 的，这语句竟然不通用。如何写的呢？请指教一下，哪里出错了？

...全文

保姆级教程：用NodeMediaClient在Android实现RTMP拉流播放（附避坑指南）本文提供了一份详尽的Android平台RTMP拉流播放实现与深度调优指南。重点介绍了如何使用NodeMediaClient库进行集成，并针对视频卡顿、花屏等常见问题，从渲染引擎选择（SurfaceView与TextureView）、解码策略、缓冲区优化到高级网络自适应等方面提供了实战解决方案与避坑技巧。阅读详情

EexeNet

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

EexeNet 2011-02-21

打赏
举报

很好，结贴，谢谢大家，特别感谢
ssp2009

zhuosh 2011-02-21

打赏
举报

SQL code
select * from
(SELECT a.* FROM Ay_Class AS a where a.bId=14
union
select b.* from Ay_Class AS a
INNER JOIN Ay_Class AS b ON a.bParent = b.bId where a.bId=14 ) aa
order by bParent,bOrder

快溜 2011-02-21

打赏
举报



 --如果改为 

a.bParent = b.bId where a.bId=14 ) as aa

 --你应该就懂了。

EexeNet 2011-02-21

打赏
举报

ssp2009 你好，感谢你的答复，问一下，你的：a.bParent = b.bId where a.bId=14 ) aa

aa 是什么呢？

快溜 2011-02-21

打赏
举报



select * from 

(SELECT a.* FROM Ay_Class AS a where a.bId=14 

   union 

  select b.* from Ay_Class AS a 

       INNER JOIN Ay_Class AS b ON a.bParent = b.bId where a.bId=14 ) aa

order by bParent,bOrder

快溜 2011-02-21

打赏
举报

select * from 

(SELECT a.* FROM Ay_Class AS a where a.bId=14 

   union 

  select b.* from Ay_Class AS a 

       INNER JOIN Ay_Class AS b ON a.bParent = b.bId where a.bId=14 ) 

order by bParent,bOrder

EexeNet 2011-02-21

打赏
举报

access : select * from (SELECT a.* FROM Ay_Class AS a where a.bId=14 union (select b.* from Ay_Class AS a INNER JOIN Ay_Class AS b ON a.bParent = b.bId where a.bId=14) ) order by bParent,bOrder

这句，又是哪错了，在sqlserver 提示 order 附近有错，

也需要改成 mssql里运行的

快溜 2011-02-21

打赏
举报



SELECT Ay_Content.*, Ay_Class.bName AS bClassName, Ay_Class.bParent AS bParentID,

 IIf(IsNull(c.bCommentCount),0,c.bCommentCount) AS bCommentCount

FROM Ay_Content a

LEFT JOIN Ay_Class b ON a.bClassID = b.bId

LEFT JOIN (select bArtID,count(*) as bCommentCount from Ay_Comment group by bArtID) c 

            ON a.bId = c.bArtID;

AcHerat 元老 2011-02-21

打赏
举报



SELECT Ay_Content.*, Ay_Class.bName AS bClassName, Ay_Class.bParent AS bParentID, IsNull(c.bCommentCount,0) AS bCommentCount

FROM Ay_Content LEFT JOIN Ay_Class ON Ay_Content.bClassID = Ay_Class.bId

    LEFT JOIN (select bArtID,count(*) as bCommentCount from Ay_Comment group by bArtID) AS c ON Ay_Content.bId = c.bArtID

一条access 里的语句，麻烦帮我改写成 ms sqlserver 里面的语句

相关推荐