{"id":1929,"date":"2020-02-16T22:33:56","date_gmt":"2020-02-16T22:33:56","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1929"},"modified":"2020-02-16T22:40:02","modified_gmt":"2020-02-16T22:40:02","slug":"line-numbers-in-ssms-v18","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=1929","title":{"rendered":"Enabling Line Numbers in SSMS v18"},"content":{"rendered":"<p>Working with large sql statements, I find it is easier to have line numbers in the query window.<\/p>\n<p>Enabling &#8220;Line numbers&#8221; process is the same with every version of SQL Server Management Studio since version that came with SQL Server 2005 (Version 9).<\/p>\n<p>To enable line numbers in the query window:<\/p>\n<p>1. Click on the Tools drop down menu<\/p>\n<p>2. Click on the Options in the drop down menu<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_01.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1930 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_01.jpg\" alt=\"\" width=\"739\" height=\"473\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_01.jpg 739w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_01-300x192.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_01-210x134.jpg 210w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/a><\/p>\n<p>When the Options pop-up box opens:<\/p>\n<p>1. Expand &#8220;Text Editor&#8221;<\/p>\n<p>2. Expand &#8220;All Languages&#8221;<\/p>\n<p>3. Click on the &#8220;General&#8221; option<\/p>\n<p>4. Click in the &#8220;Line numbers&#8221; checkbox, and click\u00a0 the OK button of the Options pop-up box<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_02.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1931 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_02.jpg\" alt=\"\" width=\"727\" height=\"498\" \/><\/a><\/p>\n<p>Line numbers will be part of every current &amp; new query window unless its undone.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_03.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1932 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_03.jpg\" alt=\"\" width=\"695\" height=\"425\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_03.jpg 695w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_03-300x183.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/SSMS18_LineNumbers_03-210x128.jpg 210w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Working with large sql statements, I find it is easier to have line numbers in the query window. Enabling &#8220;Line numbers&#8221; process is the same with every version of SQL &hellip; <a class=\"readmore\" href=\"https:\/\/www.theSQLReport.com\/?p=1929\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1931,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[180,181,144,81],"class_list":["post-1929","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-line-numbers","tag-query-window","tag-sql-server-management-studio","tag-ssms"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1929"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1929"}],"version-history":[{"count":2,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1929\/revisions"}],"predecessor-version":[{"id":1934,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1929\/revisions\/1934"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1931"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}