update a table with consequtive integers

Question

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

g-168250 Valued Member Points: 60 More actions · Answer 1

3RD time lucky

declare @v1 int

set @v1 = 105000

update a

set @v1 = @v1+1,

a.attribute_id = @v1

from YourTable a

where isnull(a.attribute_id,0) = 0

Sergei Zarembo Hall of Fame Points: 3887 More actions · Answer 2

Thank you, q! I checked this, it works. The way u did it is much more clear and faster.

Sergei

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

check this out for more information on this method and why you shouldn't use it :

Also this may run faster if attribute_id is indexed :

declare @v1 int

set @v1 = 105000

update dbo.YourTable set @v1 = @v1+1, attribute_id = @v1 where attribute_id is null

Sergei Zarembo Hall of Fame Points: 3887 More actions · Answer 4

Thank u, I will. Needless to say it looks pretty deep to me :=)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

It looked pretty deep for most of the persons browsing this forum .