Question

i have a problem with Update in Ms Sql Server(TSQL)
suppose that i have a table Person with Description and ID fields and inserted 1000 record to this table with this value

  1      Descript1
  2      Descript2
  3      Descript3
  ..       ......
  ..      ......
  1000   Descript1000

我怎样才能改变这1000个记录在记录下相同的记录?

1   Description1
2    Description2
3     Description3
......
......
1000      Description1000

should i use cursor? i wrote this query but it doesnt work

    while @Counter<=1000000
      begin
          update Person set Description= Descripton +CONVERT(nvarchar(15),@Counter) where ID>=1
     set @Counter=@Counter+1
      end

Answer 1

不需要 cursor ,只需简单的 更新 :

update Person
set Description = "Description" + convert(varchar(10), ID)

Answer 2

UPDATE  Person
SET     Discription = SPACE(Z.n)+ Z.Discription
FROM (  SELECT  ID, 
                Description , 
                ROW_NUMBER() OVER (ORDER BY ID)n
        FROM Person
    )Z

友情链接