Viewing 3 posts - 1 through 3 (of 3 total)
Create table (id int, names varchar(50))
you can update id column like below.
declare @id int
set @id=0
update table
set id=@id,@id=@id+1
January 9, 2009 at 2:53 am
#923997
you can use the below
insert into
select column1,column2 from
January 9, 2009 at 2:50 am
#923993
You can use the script below...
select column1,column2... from
January 9, 2009 at 2:48 am
#923992