Insert line number in SQL Manager

Asked

Viewed 45 times

3

Hello!

I’m trying to see the number of rows on the side of my SQL Manager query, but I can’t find where to put, could anyone help me? I’m getting an error in my query and it informs the line, but it’s hard to identify without.

sql sql-server ssms

1 answer

4

Depending on your SSMS version the path is:

Top Menu >> Tools (Tools) >> Options (Options) >> Editor Text (Text Editor) >> General (General) >> Enable the option: Line (Line Number) in the Display frame.

Or:

Top Menu >> Tools (Tools) >> Options (Options) >> Editor Text (Text Editor) >> Transact-SQL >> Enable option: Numbers Line (Line Number) in the Settings frame.

  • 1

    It worked the second option, use the 2017 version. Thank you!

Browser other questions tagged sql sql-server ssms

You are not signed in. Login or sign up in order to post.