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

 37 total views,  2 views today

Leave a Reply

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