CREATE PROCEDURE UP_Get_Channel1 AS
declare @Provisional table
(
row smallint not null identity(1,1),
title VarChar(50),
content VarChar(50),
imageurl VarChar(50),
datetime DateTime,
url VarChar(50)
) insert into @Provisional (title,content,imageurl,datetime,url)
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=1 and images=1 order by datetime desc
insert into @Provisional (title,content,imageurl,datetime,url)
select top 6 title,content,imageurl,datetime,url from ac_childclass where pid=1 and images=0 order by datetime desc
insert into @Provisional (title,content,imageurl,datetime,url)
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=2 and images=1 order by datetime desc
insert into @Provisional (title,content,imageurl,datetime,url)
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=2 and images=0 order by datetime desc 这么搞下去.会不会很慢??(一直加到6)弄个循环会不会好点?已经建了组合索引
declare @Provisional table
(
row smallint not null identity(1,1),
title VarChar(50),
content VarChar(50),
imageurl VarChar(50),
datetime DateTime,
url VarChar(50)
) insert into @Provisional (title,content,imageurl,datetime,url)
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=1 and images=1 order by datetime desc
insert into @Provisional (title,content,imageurl,datetime,url)
select top 6 title,content,imageurl,datetime,url from ac_childclass where pid=1 and images=0 order by datetime desc
insert into @Provisional (title,content,imageurl,datetime,url)
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=2 and images=1 order by datetime desc
insert into @Provisional (title,content,imageurl,datetime,url)
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=2 and images=0 order by datetime desc 这么搞下去.会不会很慢??(一直加到6)弄个循环会不会好点?已经建了组合索引
解决方案 »
- 一个小问题...帮忙看一下下????????????????????????????????????????????????????????????????
- 请教SQLSERVER里用TOP取数据的问题
- MSSQL2005 XML 查询问题!高手来吧~
- 如何根据两个条件来进行排序?
- 求一个复杂的sql问题
- 请教一下如何在C#的程序中执行T-SQL的数据库脚本,实现数据库复制?
- 跨数据库调用存储过程操作本地表的问题!!!请各位帮忙!!!
- 如何写转字段的代码值为真正值的SQL语句?
- 在SQL server触发器中同步oracle数据,有错误!急救!!!
- 存储过程:全文目录填充的问题!?
- 如何知道数据库中各种表之间的关系?
- case/null 出错?
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=1 and images=1 order by datetime desc
union all
select top 6 title,content,imageurl,datetime,url from ac_childclass where pid=1 and images=0 order by datetime desc
union all
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=2 and images=1 order by datetime desc
union all
select top 2 title,content,imageurl,datetime,url from ac_childclass where pid=2 and images=0 order by datetime desc