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

What is the Bookmark Lookup and RID Lookup in SQL Server ?

What is Central Management in SQL Server ?

Getting List of All Stored Procedures in Database in MS SQL

What are the Different Recovery Models Inside SQL Server ?