sql tool

Displaying line numbers in Query Editor Window

We can enable line numbers to be displayed in Sql Server Query Editor Window. It is very helpful when working on a large query set  or stored procedures .

By default line numbers are disabled in Query editor window ,to enable it there are few steps as given below.

Step 1> Go to header menu > Click on Tool > option


sql tool


Step 2> On Options window > navigate to Text Editor > Transact-SQL > General >Tick  ‘Line Number’


sql line number

Step 3> Finally Click on ‘OK‘ button

Now, when a query editor window is opened Line Numbers will be displayed as shown below.

line number

SQL Server Tricks & Trips

 165 total views,  1 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.