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

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

看代码

 execute update_company_intergrity 1  declare @id intdeclare @count intset @id=1SELECT @count = max(ID) FROM   manager_companydetails  WHILE @id <= @countBEGINexecute update_company_intergrity @id         SET @id  = @id +1END ;