62,263
社区成员
发帖
与我相关
我的任务
分享如何快速计算出两个表用UNION ALL 后的总计录数在数据30或40万的数下
如何快速计算出两个表用UNION ALL 后的总计录数在数据30或40万的数下
请帮忙快速解决
请帮忙快速解决
...全文
请发表友善的回复…
发表回复
「已注销」 2007-02-02
- 打赏
- 举报
这个就是查询语句，服务器是我们局域网里的
「已注销」 2007-02-02
- 打赏
- 举报
string sql;
sql="select count(id) as id from (SELECT top 800 id as id,gjzname AS title, webcontent AS content, weburl AS http,addtime as addtime,";
sql=sql+"price as onclick,1 as type,yhid as hyid FROM s_gjz WHERE shenhe=1 and ";
sql = sql + "(gjzname = '" + words + "' or webcontent = '" + words + "') UNION ALL ";
sql=sql+"SELECT top 800 id as id,title AS title, content AS content ,http AS http, addtime as addtime,";
sql=sql+"onclick as onclick,0 as type,0 as ";
sql=sql+"hyid FROM jxsbss where ifzdlr=2 and shenhe=1 and ";
sql = sql + "(title LIKE '%" + words + "%' or content like '%" + words + "%' or company like '%" + words + "%') order BY type desc, onclick desc, ";
sql=sql+"addtime DESC) as idd";
SqlCommand com = new SqlCommand(sql, sharee.con);
SqlDataReader dread = com.ExecuteReader();
if (dread.Read())
{
rcount = Int32.Parse(dread["id"].ToString());
}
else
{
rcount = 0;
}
sql="select count(id) as id from (SELECT top 800 id as id,gjzname AS title, webcontent AS content, weburl AS http,addtime as addtime,";
sql=sql+"price as onclick,1 as type,yhid as hyid FROM s_gjz WHERE shenhe=1 and ";
sql = sql + "(gjzname = '" + words + "' or webcontent = '" + words + "') UNION ALL ";
sql=sql+"SELECT top 800 id as id,title AS title, content AS content ,http AS http, addtime as addtime,";
sql=sql+"onclick as onclick,0 as type,0 as ";
sql=sql+"hyid FROM jxsbss where ifzdlr=2 and shenhe=1 and ";
sql = sql + "(title LIKE '%" + words + "%' or content like '%" + words + "%' or company like '%" + words + "%') order BY type desc, onclick desc, ";
sql=sql+"addtime DESC) as idd";
SqlCommand com = new SqlCommand(sql, sharee.con);
SqlDataReader dread = com.ExecuteReader();
if (dread.Read())
{
rcount = Int32.Parse(dread["id"].ToString());
}
else
{
rcount = 0;
}
「已注销」 2007-02-02
- 打赏
- 举报
不行呀，老是连接超时呀
syeerzy 2007-02-02
- 打赏
- 举报
count 函数啊晕 count(*) 或count(1)不就行了?
「已注销」 2007-02-02
- 打赏
- 举报
请朋友们帮忙了··············
「已注销」 2007-02-02
- 打赏
- 举报
自己顶了！！！！！！！！！
