Blog

Author: Created: 11/11/2017 11:59 AM RssIcon
Covering Excel, SQL Server, PowerBI, Machine Learning, and more...
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.

SOLUTION:

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

image

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:

image

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

AdventureWorks2016.bak

Search

Categories

Recent Posts

Writing SQL Queries: Display Line Numbers
Welcome To My Blog