The thing to keep in mind is that the site has various levels of people using SQL Server. You a life saver!!!!īack To Top - thanks for your feedback. Wow.this really helps! I am new to SQL Server. We were all beginners once and I see nothing wrong with trying to help them at.
#SQL SERVER STUDIO MANAGER 2012 HOW TO#
Thanks for pointing out how to enable this.īack To Top There is room for tips that are targetted at the absolute beginners as well. I had seen Line Numbers display in SSMS while attending few webcasts and always wondered how to get this feature enabled as this is so useful in day-to-day work. Wow! Thanks MSSQLTips for this quick tip. we were also newbies at one point.Īnother cool thing in SSMS around line numbers is if you double-click an error message in the results pane, it usually takes you to the line that has the error!
Yeah, you never know who's reading a tip, so it's good to include newbies where possible. In that case, double-clicking the error message is really the only way to find the offending line. That is, if the error message complains about line 17, it is not really line 17, it is the 17th line withing the scipt. If you have more than one script in a query window, which I do often enough, then it is frustrating to find the the error message gives you a line number *within the specific script*. If you did not need it, fine, but that does not mean that no one else did. Zen: Yes, it was a tip, and it was useful to me. But I DO know how to turn my computer on, so no need for a tip on that. Also, handy to know that double-clicking the error takes me right to the error. I'm not an absolute beginner, but I'd have spent way too much time looking for this myself. A quick google searched showed this article.
#SQL SERVER STUDIO MANAGER 2012 CODE#
Thanks for this tip! I'm not new to SSMS, but I haven't written much SQL code in it - done that in external tools. Saturday, Octo1:54:26 AM - Arnor Baldvinsson Thanks for sharing and keep the basic reminders coming. Then when I need it, I can't remember how to get to it. If I do not consistently use a tool, I will forget about it. I like having some basic tips and they are not only for beginners. Well, I'm a "seasoned beginner" and I did not know how to turn on the line count, nor about the double-click error jump. I Love MSSQLTips as they bringing something new every day for every learner. Also huge thanks to Fatherjack for his tip as well! Wednesday, Janu1:02:36 AM - vikrant thakkar
Thanks for the very easy too follow explanation!Īll you have to do to find an error by line number is double click on the error message and SSMS takes you directly to it. In SSMS v17.1 which I have installed, the Line Number option is found in a different place Options | Text Editor | Transact-SQL | Settings Thanks for the effort of step by step explaining.
0 kommentar(er)
