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
Step 2> On Options window > navigate to Text Editor > Transact-SQL > General >Tick ‘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.
165 total views, 1 views today