Resources For IT Professionals

United States (English) Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by SathyanarrayananS (8Microsoft Community Contributo)
When: 20 Jul 2013 2:56 AM
Last revision by Naomi N (eMicrosoft Partne)
When: 20 Jul 2013 9:50 PM
Revisions: 4
Comments: 1

Options

Subscribe to Article (RSS)

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SQL Server Management Studio: How to Add Line Numbers

I have seen many times in MSDN SQL Server Tools Forum forum users asking how to add line numbers in SSMS or how to count the number of lines of code.

In SQL Server Management Studio there is a provision to add line numbers and it is really simple to add.

In SSMS, Goto Tools - > Options ... -> Text Editor - > Transact - SQL - > General - > Display - > Line numbers (check this option to display line numbers on Query window)

Once line numbers are added, if you have T-SQL code of 1000 lines or more on your query window, the shortcut key to go particular line number is CTRL + G
If you notice at the bottom of SSMS, you can see Ln (N), where N denotes the line number of current cursor position (as highlighted in below screenshot)