این کد اس کیو ال چی میگه ؟

[korosh00]

سلام
می خوام یکی ازدوستان بگه این کد بعدازساختن جداول چه چیزی رو میگه ؟
ممنون


USE [master]
GO


CREATE DATABASE [ImagesDB]
GO


USE [ImagesDB]
GO


SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[Images](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](30) NOT NULL,
[Url] [nvarchar](200) NOT NULL,
CONSTRAINT [PK_Images] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO




CREATE PROCEDURE [dbo].[GetImagesPageWise]
--[dbo].[GetImagesPageWise] 2, 10, null
@PageIndex INT = 1
,@PageSize INT = 3
,@PageCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;


SELECT ROW_NUMBER() OVER
(
ORDER BY [Id] ASC
)AS RowNumber
,Id
,Name
,Url
INTO #Results
FROM [Images]


DECLARE @RecordCount INT
SELECT @RecordCount = COUNT(*) FROM #Results


SET @PageCount = CEILING(CAST(@RecordCount AS DECIMAL(10, 2)) / CAST(@PageSize AS DECIMAL(10, 2)))
PRINT @PageCount

SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #Results
END

[korosh00]

کسی جواب نمیده ؟