付费求助thinkphp 链接数据库sqlserver2000分页出错问题

浏览:743 发布日期:2013/09/29 分类:求助交流
[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)
付费求助
联系QQ:401167775
最佳答案
评论( 相关
后面还有条评论,点击查看>>