title: Iterate through Each Record In a Table with Non-identity column SQL
body: <p>I need to Iterate through Each Record In a <code>Table</code> and assign that <code>record</code> value to a <code>variable</code> using <code>while</code> loop. The table doesn't have any <code>Identity</code> or <code>sequence</code> column. I know that we can create a <code>temp table</code> with <code>table data</code> and <code>identity column</code> or <code>Rownumber</code> and use it for Each Record iteration. Is there any other way around to select <code>rownumber</code> for a particular record <code>implicitly</code> for each <code>row</code>?</p>