¾È³çÇϼ¼¿ä °»ç´Ô.
ÇöÀç "ASP.NET ±âÃÊÀÔ¹® Part2-Web Forms 4.6 °Ô½ÃÆÇ ÇÁ·ÎÁ§Æ® - Visual Studio 2015"±â¹Ý °Á¸¦ µè°í ÀÖ½À´Ï´Ù.
ÀÌ °Á¿¡¼´Â Stored Procedure¿¡ ´ëÇÑ ¼³¸íÀÌ »ý·«µÇ¾îÀÖ¾î ³ª¸§ °»ç´ÔÀÇ ÀڷḦ º¸°í ÀÌÇØÇÏ·Á°í ÇßÀ¸³ª
ListNote µîÀÇ ±¸¹®Àº ±âÁ¸¿¡ °øºÎÇß´ø ±¸¹®°ú´Â Á» ´Þ¶ó¼ ÀÌÇØÇϱⰡ ¾î·Æ½À´Ï´Ù.
±âÁ¸¿¡ ¸®½ºÆ® ±¸¹®ÀÌ¾ß ¸ðµç Çʵ峪 ¿øÇÏ´Â Çʵ带 selectÇÏ¸é µÇ¾úÁö¸¸ À̹ø Àå¿¡¼´Â ´Ù¼Ò º¹ÀâÇؼ Àß ÀÌÇØ°¡ ¾È°©´Ï´Ù.
Ȥ½Ã, Dotnet Note °Ô½ÃÆÇ °ü·ÃÇÏ¿© procedure¿¡ÇÑ °Á°¡ ÀÖÀ¸¸é ¾Ë·ÁÁÖ¼ÌÀ¸¸é ÇÕ´Ï´Ù.
³ª¸§ ¿½ÉÈ÷ µû¶ó¼ ÇÏ°í´Â Àִµ¥ ¾ÆÁ÷±îÁöµµ ÀÀ¿ë·ÂÀÌ ºÎÁ·Çؼ Á¶±Ý¸¸ ¾î·Á¿öÁö¸é ¸Ó¸®°¡ ÇϾêÁý´Ï´Ù..
Áñ°Å¿î ÇÏ·ç µÇ½Ê½Ã¿À
Create Procedure dbo.ListNote
@Page int
As
With DotnetNoteOrderedLists
As
(
Select ID, Name, Email, PostDate, ReadCount, Ref, Step, RefOrder, AnswerNum, ParentNum, CommentCount, FileName, FileSize, DownCount,ROW_NUMBER() Over( Order By Ref Desc, RefOrder Asc)As 'RowNumber' From Notes
)
Select * From DotnetNoteOrderedLists Where RowNumber Between @Page*10+1 And(@Page+1)*10
Go
|