我想把下面的语句改成可以在MSSQL2000中运行的语句,由于2000中不支持row_number() over而客户非要2000只能这样作了
string sql = "SELECT ROW_NUMBER() OVER (ORDER BY zgi_name, zti_id) AS ROW, * FROM View_ZT_Info where ZTI_ZuangTai='" + Request["ZTI_ZuangTai"].Trim() +"'";1. 目的:
根据展馆的状态在展台信息视图中查询出展台的数据,然后展台的数据以展馆名和展台的ID进行排序的2. 我改的如下:
string sql = "select count(select count(1) from view_zt_info order by zti_id desc) from view_zt_info where ZTI_ZuangTai='" + Request["ZTI_ZuangTai"].Trim() + "' order by zgi_name desc";
这个有问题?测试通不过的。3. 这个语句的拆分为: //1. select count(1) from view_zt_info where ZTI_ZuangTai='" + Request["ZTI_ZuangTai"].Trim() +"'" order by zgi_name //2. select count(1) from view_zt_info order byzti_id;
现在不会作了,望高手帮忙?谢谢
string sql = "SELECT ROW_NUMBER() OVER (ORDER BY zgi_name, zti_id) AS ROW, * FROM View_ZT_Info where ZTI_ZuangTai='" + Request["ZTI_ZuangTai"].Trim() +"'";1. 目的:
根据展馆的状态在展台信息视图中查询出展台的数据,然后展台的数据以展馆名和展台的ID进行排序的2. 我改的如下:
string sql = "select count(select count(1) from view_zt_info order by zti_id desc) from view_zt_info where ZTI_ZuangTai='" + Request["ZTI_ZuangTai"].Trim() + "' order by zgi_name desc";
这个有问题?测试通不过的。3. 这个语句的拆分为: //1. select count(1) from view_zt_info where ZTI_ZuangTai='" + Request["ZTI_ZuangTai"].Trim() +"'" order by zgi_name //2. select count(1) from view_zt_info order byzti_id;
现在不会作了,望高手帮忙?谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货