select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表 select * from #temp where ID_Num>10 and ID_Num<200
谢谢 pengdali(大力) !请问在大数据量时,那一种方法效率高些?
select top 190 * from #temp where cid not in (select top 10 cid from #temp)
大侠们能不能帮我看看,为什么我把它写成存储过程, 提示 第 7 行: '@PageNumber' 附近有语法错误。 第 8 行: '@RecordNumber' 附近有语法错误。CREATE PROCEDURE List_Notice ( @PageNumber int, @RecordNumber int ) AS select top @PageNumber*@RecordNumber * from Notice_Info where NoticeID not in (select top @RecordNumber*(@PageNumber-1) NoticeID from Notice_Info order by SubmitTime desc) order by SubmitTime desc GO
select top 200 * from (select top 210 * from table order by field desc)
SELECT Top @分页的大小 * FROM T WHERE SortField NOT IN (SELECT TOP @分页的大小 * @页号 SortField FROM T ORDER BY SortField ) ORDER BY SortField
to pengdali(大力) 下面代码发到存储过程还是出错 提示Top后面不是真确的TSQL语句 CREATE PROCEDURE List_Notice ( @页号 int, @分页的大小 int ) ASSELECT Top @分页的大小 * FROM T WHERE SortField NOT IN (SELECT TOP @分页的大小 * @页号 SortField FROM T ORDER BY SortField ) ORDER BY SortField
CREATE PROCEDURE List_Notice ( @页号 int, @分页的大小 int ) AS set @临时变量=@分页的大小 * @页号 exec('SELECT Top '+@分页的大小+' * FROM T WHERE SortField NOT IN (SELECT TOP '+@临时变量+' SortField FROM T ORDER BY SortField ) ORDER BY SortField')
select * from #temp where ID_Num>10 and ID_Num<200
select top 190 * from #temp where cid not in (select top 10 cid from #temp)
提示
第 7 行: '@PageNumber' 附近有语法错误。
第 8 行: '@RecordNumber' 附近有语法错误。CREATE PROCEDURE List_Notice
(
@PageNumber int,
@RecordNumber int
)
AS
select top @PageNumber*@RecordNumber * from Notice_Info where
NoticeID not in (select top @RecordNumber*(@PageNumber-1) NoticeID from Notice_Info order by SubmitTime desc)
order by SubmitTime desc
GO
FROM T
WHERE SortField NOT IN (SELECT TOP @分页的大小 * @页号
SortField
FROM T
ORDER BY SortField
)
ORDER BY SortField
下面代码发到存储过程还是出错
提示Top后面不是真确的TSQL语句
CREATE PROCEDURE List_Notice
(
@页号 int,
@分页的大小 int
)
ASSELECT Top @分页的大小 *
FROM T
WHERE SortField NOT IN (SELECT TOP @分页的大小 * @页号
SortField
FROM T
ORDER BY SortField
)
ORDER BY SortField
(
@页号 int,
@分页的大小 int
)
AS
set @临时变量=@分页的大小 * @页号
exec('SELECT Top '+@分页的大小+' *
FROM T
WHERE SortField NOT IN (SELECT TOP '+@临时变量+'
SortField
FROM T
ORDER BY SortField
)
ORDER BY SortField')