TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Susanta Rout
779
1.1k
127.2k
line by line meaning of this query
Sep 5 2015 1:56 AM
CREATE
PROCEDURE
GetCustomersPageWise
@PageIndex
INT
=
1
,
@PageSize
INT
=
10
,
@RecordCount
INT
OUTPUT
AS
BEGIN
SET
NOCOUNT
ON
;
SELECT
ROW_NUMBER
()
OVER
(
ORDER
BY
[CustomerID]
ASC
)
AS
RowNumber
,
[CustomerID]
,
[CompanyName]
,
[ContactName]
INTO
#Results
FROM
[Customers]
SELECT
@RecordCount
=
COUNT
(*)
FROM
#Results
SELECT
*
FROM
#Results
WHERE
RowNumber
BETWEEN(
@PageIndex
-
1
)
*
@PageSize
+
1
AND(((
@PageIndex
-
1
)
*
@PageSize
+
1
)
+
@PageSize
)
-
1
DROP
TABLE
#Results
this query used by someone for paging in reapter i want to know what are the meaning of this query
Reply
Answers (
8
)
Have an issue in Entity Framework Code First
Finding the most efficient way of transferring data