解决sqlsrv连接sql2000不支持ROW_NUMBER()函数

浏览:1860 发布日期:2013/09/29 分类:发布项目
项目描述:解决sqlsrv连接sql2000不支持ROW_NUMBER()函数,分布问题


薪 酬:200

完成时间:2013-10-1

联系电话:[phone] [error:protected] => 在关键字 'AS' 附近有语法错误。
[ SQL璇彞 ] : SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT convert(varchar(255),NameStr) as NameStr,convert(varchar(255),Picture) as Picture,convert(varchar(255),ID) as ID,MemberPrice,MarketPrice,Points FROM w_product WHERE ( SubClassification = '31141106' ) AND ( State = 1 )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 5)[/phone]

联系邮箱:

其他信息:QQ:401167775
最佳答案
评论( 相关
后面还有条评论,点击查看>>