Update a table column with sequence number

Assume that you already have a table with 1000 rows. Now suppose, after some months, you feel a need to insert a sequence number column in the same table. Here is a script that I have worked out. If you have anyother better way then you are most welcome to comment on the same!

4 (2)

2006-03-28 (first published: )

357 reads

Blogs

Weekly reading #15

By

SQLDay 2019 is gone. The Data Community.PL has now a new goal – it...

Last Weeks Reading (2019-05-26)

By

It was tremendously extensive week for me (a week ago) when I spent time...

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Streamlining a Power BI Solution

By Additional Articles

Comments posted to this topic are about the item Streamlining a Power BI Solution

Proverbial Tree Barking

By maverickuk82

Hi All, I'm just after a pointer really. I've had an idea. I want...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers