多表查询并分页显示问题
来源:百度知道 编辑:UC知道 时间:2024/05/16 15:27:45
不好意思,我没有说明白,用ASP
关于一个多表交叉读出数据的效率问题,是先全写成视图,然后用存储过程分页读取,还是直接用存储过程拼接这么复杂的sql语句分页显示好
这个sql语句如下:
------------------------------------
string sql= "SELECT A.Company_ID,A.Company_Name,A.Company_Attribute,A.Company_Scale,"+
"B.Pub_Position_ID,B.Company_ID,B.Pub_Position_Name,"+
"B.Pub_Position_Number,B.Pub_Position_Age,B.Pub_Position_Sex,B.Pub_Position_Academic,"+
"Pub_Position_Date = replace(convert(varchar(10),B.Pub_Position_Date,102),'.','-'), "+
"B.Pub_Position_Work_Area_Province,B.Pub_Position_Work_Area,B.Pub_Position_Salary,"+
"AgeRange=cast(B.Pub_Position_MinAge as varchar)+'-'+cast(B.Pub_Position_MaxAge as varchar),"+
"valid