SQL Server Tips - Add Line Numbers

 One of our simplest SQL server tips and timesavers is to enable line numbers in SQL Server

When your queries start to get long, one of the most helpful things is to turn on sql line numbers

This is especially helpful when collaborating with others as it makes it easy to draw attention to a specific area in the code

 To enable line numbers click on Tools --> Options 

Then click on Text Editor and under the Transact-SQL section 

and select the  Line numbers check box