calculating values for earch record with SP at once..

[jonasggg]

hello,

I imported a table to sql server which it hasnt identity field. I created a field now but how can I give the correlative numbers at once in Stored Procedure to all the records? thank in advance.
For example ->
name last_name Cnt price total
John Smith 1 10
Sarah Smith 1 15
Marta Smith 1 13

to:

id name last_name Cnt Price Total
1 John Smith 1 10
2 Sarah Smith 1 15
3 Marta Smith 1 13


Another thing..
how can I calculate the total (cnt x price) at once for each records?
Thanks!!

 

[checkai]

The ID field should populate automatically if you really made it an Identity....

the total field isn't necessary, you should be doing these calculations elsewhere (stored proc when needed, view, etc.)

but if you really want it...

update tableName
set total = cnt * price

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."