¾È³çÇϼ¼¿ä.
ÆäÀÌÁö ó¸® °ü·ÃÇؼ´Â
¾Æ·¡ SQL Server °Á¸¦ Âü°íÇØ º¸½Ã¸é µË´Ï´Ù.
http://www.devlec.com/?_pageVariable=SPECIALCOURSE&cIdx=960&_pageMenu=
46ȸ. Row_Number ÇÔ¼ö·Î ÆäÀÌ¡ ó¸®
À§ 46ȸ °ÀÇ¿¡ ÆäÀÌ¡ °ü·Ã Äõ¸®¹®À» ¼³¸íÇØ ³õ¾Ò½À´Ï´Ù.
Âü°í·Î,
½¬¿î ÇüÅÂÀÇ °Ô½ÃÆÇ °Á´Â
ASP.NET 3.5 °Ô½ÃÆÇ ÇÁ·ÎÁ§Æ® Part 1~4 °Á¸¦ Âü°íÇØ º¸¼Åµµ µË´Ï´Ù.
ÀÌ»óÀÔ´Ï´Ù.
±èÁø¸¸ ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä °»ç´Ô.
ÇöÀç "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
|