title: How to get Column value without knowing column name ? SQL Server
body: <p>I have table name as <code>@Table_Name</code></p>
  
  <p>I have column value as <code>@Value</code> but don't have the column name (but that exist at 1st position and can be Seek_id or prov_id ...I have to compare my value with this id )</p>
  
  <p>How can I compare that table column name value ?</p>
  
  <p>I want something like</p>
  
  <pre><code>SELECT * FROM @Table_Name
  WHERE Table.Column[1].Value = @Value
  </code></pre>
  
  <p>for example <code>@Table_Name = bb_match</code> and <code>@Value = 6</code></p>