title: How to find column in value list easily in Management Studio?
body: <p>I've been trying to find some way to simplify editing/adding a value to the corresponding column inside Insert-clauses when coding inside SQL inside Managagement Studio 2008 R2.</p>
  
  <p>Assume the following code:</p>
  
  <pre><code>INSERT INTO [Schema].[Table]
                  ( [Col1],
                    [Col2],
                    [Col3],
                    [Col4],
                    [Col5],
                    [Col6],
                    [Col7],
                    [Col8],
                    [Col9],
                    [Col10],
                    [Col11],
                    [Col12],
                    [Col13],
                    [Col14],
                    [Col15],
                    [Col16],
                    [Col17],
                    [Col18]
  
                  )
           VALUES
                  (
                    232,
                    0,
                    NULL,
                    NULL,
                    0,
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    0,
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    NULL
  </code></pre>
  
  <p>Say I want to change a value in the 11th column, I have to start counting to see which value corresponds to that column. Perhaps it's not that difficult in this example but many real life tables contains a lot of columns. This becomes more difficult if there are a lot of NULLS in the value list. Even with line numbers enabled.</p>
  
  <p>Is there a way to have, for example a tooltip at mouse over on the value in the value list to see which column it belongs to?</p>
  
  <p>In my dream world I would right click on the column name in the Insert Into and choose something like "Go to value...".</p>
  
  <p>I'm using the free ApexSQL tools but I haven't found a function that enables me to do it. Are there any similar tools that allows me to do this?</p>
  
  <p>Thanks in advance and hope I'm not too ambigious in what I'm trying to achieve.</p>