http://springboardsolutions.com/wiki/index.php?action=history&feed=atom&title=Number_Rows_in_a_TableNumber Rows in a Table - Revision history2026-10-17T02:42:14ZRevision history for this page on the wikiMediaWiki 1.25.2http://springboardsolutions.com/wiki/index.php?title=Number_Rows_in_a_Table&diff=369&oldid=prevWikiSysop: 1 revision imported2016-03-25T08:51:12Z<p>1 revision imported</p>
<table class='diff diff-contentalign-left'>
<tr style='vertical-align: top;'>
<td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 08:51, 25 March 2016</td>
</tr><tr><td colspan='2' style='text-align: center;'><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>WikiSysophttp://springboardsolutions.com/wiki/index.php?title=Number_Rows_in_a_Table&diff=367&oldid=prevWikiSysop at 21:05, 27 May 20152015-05-27T21:05:25Z<p></p>
<p><b>New page</b></p><div>Say you have a [[Microsoft SQL Server]] table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In [[Oracle Database]] you would simply update the column with rownum:<br />
<br />
<pre><br />
update MyTable set SequenceNum = rownum<br />
</pre><br />
<br />
In SQL Server, we need to set up a counter and then increment it as we go:<br />
<br />
<pre><br />
declare @intCounter decimal(15,0)<br />
select @intCounter = 0<br />
update MyTable set @intCounter = SequenceNum = @intCounter + 1<br />
</pre><br />
<br />
[[Microsoft SQL Server]]</div>WikiSysop