Update a table column with a sequence number v3

Both Sachinvaishnav and Mark Chad have submitted scripts to populate a column with a sequence number. The first solution uses a cursor; the second uses the SQL 2005 ROW_NUMBER() function.v1:http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1643v2:http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1664Since neither script requires a specific order for the sequence number, the same result can be achieved with a single UPDATE statement.

2006-04-26 (first published: )

334 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

Azure SQL Migrations using Azure Data Studio

By bake13

Comments posted to this topic are about the item Azure SQL Migrations using Azure...

Poor Work Management

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Poor Work Management

Author Power BI Reports on Real-Time ServiceNow Data

By JerodJ

Comments posted to this topic are about the item Author Power BI Reports on...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers