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

more info...