{"id":1886,"date":"2021-02-05T08:02:20","date_gmt":"2021-02-04T23:02:20","guid":{"rendered":"http:\/\/blog.anyons.net\/?p=1886"},"modified":"2022-07-12T14:43:02","modified_gmt":"2022-07-12T05:43:02","slug":"mssql-paging","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=1886","title":{"rendered":"MSSQL Paging"},"content":{"rendered":"\n
          SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *\n          FROM [tb_Service] AS [t]\n          WHERE 1=1\n          ORDER BY [fd_nIdService] DESC\n          OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY<\/pre>\n
\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"
 SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, * FROM [tb_Service] AS [t] WHERE 1=1 ORDER BY [fd_nIdService] DESC OFFSET ((2 – 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[96],"tags":[439,112,440,437,436,438],"class_list":["post-1886","post","type-post","status-publish","format-standard","hentry","category-programming","tag-fetch","tag-mssql","tag-next","tag-offset","tag-paging","tag-rows","odd"],"yoast_head":"\nMSSQL Paging - anydragon<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/anyons.net\/?p=1886\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSSQL Paging - anydragon\" \/>\n<meta property=\"og:description\" content=\"SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, * FROM [tb_Service] AS [t] WHERE 1=1 ORDER BY [fd_nIdService] DESC OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=1886\" \/>\n<meta property=\"og:site_name\" content=\"anydragon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-04T23:02:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:43:02+00:00\" \/>\n<meta name=\"author\" content=\"anydragon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@anydragon\" \/>\n<meta name=\"twitter:site\" content=\"@anydragon\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"anydragon\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1886#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1886\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"MSSQL Paging\",\"datePublished\":\"2021-02-04T23:02:20+00:00\",\"dateModified\":\"2022-07-12T05:43:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1886\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"FETCH\",\"MSSQL\",\"NEXT\",\"offset\",\"paging\",\"ROWS\"],\"articleSection\":[\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=1886#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1886\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=1886\",\"name\":\"MSSQL Paging - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2021-02-04T23:02:20+00:00\",\"dateModified\":\"2022-07-12T05:43:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1886#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=1886\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=1886#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MSSQL Paging\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\",\"url\":\"https:\\\/\\\/anyons.net\\\/\",\"name\":\"anydragon\",\"description\":\"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang\",\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/anyons.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\",\"name\":\"anydragon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"url\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"contentUrl\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"width\":2560,\"height\":1440,\"caption\":\"anydragon\"},\"logo\":{\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\"},\"sameAs\":[\"http:\\\/\\\/anyons.net\",\"https:\\\/\\\/www.facebook.com\\\/anydragon\",\"https:\\\/\\\/x.com\\\/anydragon\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCr78KWpvmk398vPfpUTWNLg\"],\"url\":\"https:\\\/\\\/anyons.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MSSQL Paging - anydragon","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/anyons.net\/?p=1886","og_locale":"ko_KR","og_type":"article","og_title":"MSSQL Paging - anydragon","og_description":"SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, * FROM [tb_Service] AS [t] WHERE 1=1 ORDER BY [fd_nIdService] DESC OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY","og_url":"https:\/\/anyons.net\/?p=1886","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2021-02-04T23:02:20+00:00","article_modified_time":"2022-07-12T05:43:02+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=1886#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=1886"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"MSSQL Paging","datePublished":"2021-02-04T23:02:20+00:00","dateModified":"2022-07-12T05:43:02+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=1886"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["FETCH","MSSQL","NEXT","offset","paging","ROWS"],"articleSection":["Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=1886#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=1886","url":"https:\/\/anyons.net\/?p=1886","name":"MSSQL Paging - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2021-02-04T23:02:20+00:00","dateModified":"2022-07-12T05:43:02+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=1886#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=1886"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=1886#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"MSSQL Paging"}]},{"@type":"WebSite","@id":"https:\/\/anyons.net\/#website","url":"https:\/\/anyons.net\/","name":"anydragon","description":"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang","publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anyons.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b","name":"anydragon","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","url":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","contentUrl":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","width":2560,"height":1440,"caption":"anydragon"},"logo":{"@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg"},"sameAs":["http:\/\/anyons.net","https:\/\/www.facebook.com\/anydragon","https:\/\/x.com\/anydragon","https:\/\/www.youtube.com\/channel\/UCr78KWpvmk398vPfpUTWNLg"],"url":"https:\/\/anyons.net\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":228,"url":"https:\/\/anyons.net\/?p=228","url_meta":{"origin":1886,"position":0},"title":"mssql alter table column (\ud14c\uc774\ube14 \ud544\ub4dc \uc218\uc815, \uc0ad\uc81c, \ucd94\uac00) \ubc0f \ud14c\uc774\ube14\uba85, \ud544\ub4dc(\uceec\ub7fc)\uba85 \uc218\uc815","author":"anydragon","date":"2011\ub144 12\uc6d4 01\uc77c","format":false,"excerpt":"[\ucd9c\ucc98] MSSQL \ud14c\uc774\ube14\uba85 , \uceec\ub7fc\uba85 \ubc14\uafb8\uae30|\uc791\uc131\uc790 zino1187 1.\ud14c\uc774\ube14\uba85 \ubc14\uafb8\uae30 sp_rename OldTable , NewTable 2.\uceec\ub7fc\uba85 \ubc14\uafb8\uae30 sp_rename 'TableName.OldColumn','TableName.NewColumn' [\ucd9c\ucc98] mssql alter table column\uc791\uc131\uc790 \uc7ac\uc6d0\ub9e8 1. \ud14c\uc774\ube14 \ud544\ub4dc \uc218\uc815\ud558\uae30 alter table sale alter column title varchar(200) not null 2. \ud544\ub4dc \uc0ad\uc81c\ud558\uae30 alter table sale drop title 3. \ud544\ub4dc \ucd94\uac00\ud558\uae30 alter table sal\u2026","rel":"","context":""Command"\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1784,"url":"https:\/\/anyons.net\/?p=1784","url_meta":{"origin":1886,"position":1},"title":"MSSQL Table List Query","author":"anydragon","date":"2020\ub144 08\uc6d4 20\uc77c","format":false,"excerpt":"(10%) select name from sysobjects where type='U' (13%) select * from information_schema.tables (76%) select * from sys.tables","rel":"","context":""Command"\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1931,"url":"https:\/\/anyons.net\/?p=1931","url_meta":{"origin":1886,"position":2},"title":"MSSQL History","author":"anydragon","date":"2021\ub144 03\uc6d4 19\uc77c","format":false,"excerpt":"SELECT db_name(st.dbid) DBName , object_schema_name(objectid, st.dbid) SchemaName , object_name(objectid, st.dbid) SPName , qs.total_elapsed_time , creation_time , last_execution_time , text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle)st JOIN sys.dm_exec_cached_plans cp ON qs.plan_handle = cp.plan_handle \u00a0","rel":"","context":""Programming"\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":729,"url":"https:\/\/anyons.net\/?p=729","url_meta":{"origin":1886,"position":3},"title":"MSSQL \ud55c\uae00 \uc601\ubb38 \uad6c\ubd84","author":"anydragon","date":"2015\ub144 03\uc6d4 11\uc77c","format":false,"excerpt":"[\ud55c\uae00\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30] select *\u00a0 from tbl where field like '%[\uac00-\ud7a3]%' delete\u00a0 from tbl where field like '%[\uac00-\ud7a3]%' [\uc601\ubb38\uceec\ub7fc\uac12 \ub4e4\uc5b4\uc788\ub294 \uac83\ub9cc \uc9c0\uc6b0\uae30] select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%'","rel":"","context":""Programming"\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1201,"url":"https:\/\/anyons.net\/?p=1201","url_meta":{"origin":1886,"position":4},"title":"sql \uc2a4\ud06c\ub9bd\ud2b8 \uc0dd\uc131\uc2dc\uc5d0 \uc635\uc158","author":"anydragon","date":"2016\ub144 07\uc6d4 27\uc77c","format":false,"excerpt":"","rel":"","context":""Configuration"\uc5d0\uc11c","block_context":{"text":"Configuration","link":"https:\/\/anyons.net\/?cat=94"},"img":{"alt_text":"\u1109\u1173\u110f\u1173\u1105\u1175\u11ab\u1109\u1163\u11ba 2016-07-27 \u110b\u1169\u1112\u116e 3.22.20","src":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2016\/07\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2016-07-27-%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE-3.22.20.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2016\/07\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2016-07-27-%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE-3.22.20.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2016\/07\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2016-07-27-%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE-3.22.20.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2016\/07\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2016-07-27-%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE-3.22.20.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2016\/07\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2016-07-27-%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE-3.22.20.png?resize=1050%2C600 3x, https:\/\/i0.wp.com\/anyons.net\/wp-content\/uploads\/2016\/07\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA-2016-07-27-%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE-3.22.20.png?resize=1400%2C800 4x"},"classes":[]},{"id":18,"url":"https:\/\/anyons.net\/?p=18","url_meta":{"origin":1886,"position":5},"title":"OLE DB\ub85c oracle\uc774\uac74 MSSQL\uc774\uac74 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \uae30\ucd08 \ucf54\ub4dc","author":"anydragon","date":"2009\ub144 10\uc6d4 09\uc77c","format":false,"excerpt":"private OleDbDataReader rd; private OleDbConnection Conn; private string strRet; private OleDbCommand cmd; private StringBuilder sbSQL; private OleDbParameter paramnSeq; try { \/\/ SQLOLEDB MSDAORA Conn = new OleDbConnection(\"Provider=MSDAORA;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xxx )(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = GROUP))); User Id =;\u2026","rel":"","context":""Programming"\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/1886","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1886"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/1886\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}