SQL for,while循環(huán)語句

    select manages from tables
    declare @i int
    set @i=1
    while @i < (select count(*) from tables)
    begin
    update tablesset manages =(select manages from tableswhere companyid=@i)+','
    break
    set @i=@i+1
    end