Popular Posts

  • The Basics of Good T-SQL Coding Style – Part 4: Performance
    SQLServerCentral.com Articles The Basics of Good T-SQL Coding Style – Part 4: Performance There are several obvious problems with p...
  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • A Backup Change
    SQLServerCentral » Latest topics A Backup Change Comments posted to this topic are about the item [B] A Backup Change [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Thursday, August 24, 2017

how to use row number to insert into the same table ?

SQLServerCentral » Latest topics
how to use row number to insert into the same table ?
i have a table called dbo.sheet3 with 7 fields and 75 records 
I made a new column called NO and its for the total row number of the column
how to insert (1,2,3... 75 ) in the NO  column using row number function 

Regards
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)