[SQL]sql server 使用sql语句做循环

如何使用sql语句做一个循环呢

看代码

 
execute update_company_intergrity 1
  
declare @id int
declare @count int
set @id=1

SELECT @count = max(ID) FROM   manager_companydetails  


WHILE @id <= @count
BEGIN
				execute update_company_intergrity @id
 

        SET @id  = @id +1
END 
;