Technical Article

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: )

1,420 reads

Blogs

Using SQL Alerts to Spot Suspicious Activity in SQL

By

SQL doesn’t really give us too many tools out of the box to allow...

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Typing with Your Tongue Part 2: Voice Access

By

A few months ago, I wrote a post on how I use voice technology...

Read the latest Blogs

Forums

Hey!! you need some extra money to pay bills and to make ends meet? WhatsApp: ‪+

By mike201319800

--------------------------------------- Hey!! you need some extra money to pay bills and to make ends...

Hey!! you need some extra money to pay bills and to make ends meet? WhatsApp: ‪+

By mike201319800

Hey!! you need some extra money to pay bills and to make ends meet?...

same Procedure with same source tables in 2 environments but delay in exec in 1

By Zond Sita

Good Morning, I have the below procedure, in both UAT & PROD same data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers