Number Rows in a Table - Revision history

WikiSysop at 21:05, 27 May 2015

2015-05-27T21:05:25Z

← Older revision		Revision as of 21:05, 27 May 2015
Line 1:		Line 1:
-	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 you would simply update the column with rownum:	+	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:

	<pre>		<pre>

WikiSysop at 21:03, 27 May 2015

2015-05-27T21:03:18Z

← Older revision		Revision as of 21:03, 27 May 2015
Line 1:		Line 1:
-	Say you have a table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In Oracle you would simply update the column with rownum:	+	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 you would simply update the column with rownum:

	<pre>		<pre>

WikiSysop: Created page with "Say you have a table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In Oracle you would simply update..."

2013-09-17T21:40:35Z

Created page with "Say you have a table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In Oracle you would simply update..."

New page

Say you have a table (MyTable) with a number column (say 15 digits, no decimals called SequenceNum), and you want this column to count the rows. In Oracle you would simply update the column with rownum:

<pre>
update MyTable set SequenceNum = rownum
</pre>

In SQL Server, we need to set up a counter and then increment it as we go:

<pre>
declare @intCounter decimal(15,0)
select @intCounter = 0
update MyTable set @intCounter = SequenceNum = @intCounter + 1
</pre>

[[Microsoft SQL Server]]