SQL Server Performance Forum – Threads Archive
line numbers in the query window
Is there a way SQL puts the line numbers in the query windows when you are writing the code. Like Java.Can you tell I am real new to SQL?!?!?!?!
1. Select Tool | Options.
2. Expand Text Editor in the Options Tree and select All Languages.
3. In the property pane on the right, select the Line Numbers check box under the Display heading.
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by readjs</i><br /><br />Is there a way SQL puts the line numbers in the query windows when you are writing the code. Like Java.<br /><br /><br />Can you tell I am real new to SQL?!?!?!?!<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Nobody would have guessed to. [<img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ />]<br /><br />If you’re using the line number feature, be aware of the pitfall that it doesn’t necessarily correspond to the line number reported in an error message. <br /><pre id="code"><font face="courier" size="2" id="code"><br />USE tempDB<br />GO<br />CREATE TABLE #t<br />(<br /> c1 INT NOT NULLS<br />)<br /></font id="code"></pre id="code"><br />will report an error in line 3. It is reporting the line number counted starting from the last "GO" statement.<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
Dont Simulate front end feature [<img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ />]<br /><br />If you get an error, double click it and then it will point the line where error has occured<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
I believe for the sake of feature Mohammed’s tip would help and rest is upto the user [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />].<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
]]>