fakhravari
یک شنبه 10 آذر 1392, 19:37 عصر
declare @PageIndex int = 1;
declare @PageSize int = 10;
declare @RowStart int=0;
declare @RowFnish int=0;
set @RowStart = (@PageIndex -1) * @PageSize;
set @RowFnish = @PageIndex * @PageSize;
Declare @Tbl TABLE([Subject] NVARCHAR(200),[Message]NVARCHAR (max),[Rng] int);
with t1 as
(
SELECT [Subject],[Message],ROW_NUMBER() OVER (ORDER BY TopicID ASC) AS Rng FROM B_Topics
)
INSERT INTO @Tbl SELECT [Subject],[Message],Rng FROM [t1]
with t2 as
(
SELECT * FROM @Tbl WHERE Rng BETWEEN 5 AND (SELECT COUNT(*)-5 FROM @Tbl)
)
SELECT * FROM t2 WHERE Rng BETWEEN @RowStart and @RowFnish
Msg 336, Level 15, State 1, Line 16
Incorrect syntax near 't2'. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.
:متفکر:
declare @PageSize int = 10;
declare @RowStart int=0;
declare @RowFnish int=0;
set @RowStart = (@PageIndex -1) * @PageSize;
set @RowFnish = @PageIndex * @PageSize;
Declare @Tbl TABLE([Subject] NVARCHAR(200),[Message]NVARCHAR (max),[Rng] int);
with t1 as
(
SELECT [Subject],[Message],ROW_NUMBER() OVER (ORDER BY TopicID ASC) AS Rng FROM B_Topics
)
INSERT INTO @Tbl SELECT [Subject],[Message],Rng FROM [t1]
with t2 as
(
SELECT * FROM @Tbl WHERE Rng BETWEEN 5 AND (SELECT COUNT(*)-5 FROM @Tbl)
)
SELECT * FROM t2 WHERE Rng BETWEEN @RowStart and @RowFnish
Msg 336, Level 15, State 1, Line 16
Incorrect syntax near 't2'. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.
:متفکر: