Home » Displaying line numbers in Query Editor Window

Displaying line numbers in Query Editor Window

sql tool

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

Leave a Reply

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