项目描述：解决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