How to Enable Line Numbers in SQL SERVER | SQL SERVER
How to Enable Line Numbers in SQL SERVER | SQL SERVER
Enable or Disable Line Numbers in SQL Query Editor
Line numbers are the numbers next to the sql server code editor that tell you what number each line is, starting with 1 and working down. They are common in IDEs in all languages.
To turn on line numbers if SSMS, first, click the Tools menu and choose options.
then search by 'Line Number' press [ENTER], you’ll see a checkbox for Line numbers on the right. Click that.
There you GO !! BINGO !!
Why would you want to turn line number in sql server on?
Well, they are really helpful for debugging. When you get an error message, you’ll be given a line number. This refers to the line number in your SQL query that caused the error. With line numbers enabled in SQL Developer, you can see where the error comes from.
#howtoenablelinenumber
#howto
#how #sqlserver
#sql #sqlquery #sqltraining #tutorials #ssmshorts #shortsfeed
#debugging #database
=====To Get More useful video's, please follow below links ======
1.) To learn Learn SQL Server Concepts, visit below playlist
• Learn SQL Server Concepts
2.) To learn SQL Server Clauses and Keywords, please visit below playlist
• SQL SERVER CLAUSE/KEYWORDS
3.) For SSIS Tutorial, follow below playlist
• SQL SERVER Integration Services Tutor...
4.) For SSRS tutorial, follow below playlist
• SSRS Tutorials
5.) Python Tutorials, follow below playlist
• Python for Data Engineering
6.) Azure Data Factory Playlist
• Azure Data Factory Tutorial Playlist
7.) Power BI Concepts, Visit below playlist
• Power BI Concepts
8.) MS Excel and Google Sheets, follow below playlist
• MS Excel Concepts
=======My Favorite Study Materials you can check out =====
--Python Crash course :https://amzn.to/40gfFPr
--SQL Programming :https://amzn.to/40gqK2T
--MSBI Course : https://amzn.to/3Qxh94y
--Power BI Course :https://amzn.to/3QgimMl
=========Share, Support and Subscribe =========
Subscribe to my YouTube channel :
/ @learnwithmrajput
Share and like the Facebook Page :
/ 212104595551052
Thank you for Watching
By SQL
By SQL Training Session
Disclaimer : the above links may be amazon affiliate links, which means if you go through it,
I may get some commission but please bear in mind, it won't charge you a single penny
..so if you like the content, keep watching and support my channel.