By Michele Washington on 11/12/2017 10:19 PM

Whether you are a beginner or experienced writing queries you may receive an error message when you execute a query. 

SQL identifies errors within a query by line number.  Instead of counting through each line it is much more efficient to use the Line numbers option.

TOOLS:  Microsoft SQL Server Management Studio v17.2

TASK:  Select Line numbers option.


Using SQL Server Management Studio from the menu bar select Tools then Options from the dropdown menu.


By Michele Washington on 11/11/2017 12:36 PM

Hello my name is Michele and I plan to post on my adventures as I learn new technologies.

Technorati Tags:


Most of my posts will use AdventureWorks2016 database that you can get here:


Writing SQL Queries: Display Line Numbers
Welcome To My Blog