How to Show Line Numbers in MS SQL Server ?

When writing queries in MS SQL Server, clear line numbers make it easier for developers.

Showing row numbers in MS SQL Server is explained step by step below.

  • 1 - Opens "Tools" from the menu.
  • 2 - "Options" opens.
  • 3 - Select "Text Editor" from the left panel.
  • 4 - Select "All Languages".
  • 5 - Check the "Line numbers" box on the right.



You May Interest

Deleting Table With Query in MS SQL

Getting List of All Views in MS SQL Database

What are Indexed Views inside SQL Server ?

What is the Difference Between VARCHAR and NVARCHAR in SQL Server ...

What is the Maximum Size per Database for SQL Server Express ?