sql循环取出数据进行操作

    DECLARE @t TABLE ( account VARCHAR(50) )  

   DECLARE @num INT    

   DECLARE @account VARCHAR(50)      SET @num=0 

 INSERT INTO @t      

 SELECT  Account FROM dbo.frmuser WHERE DepartmentId=1 AND IsValid=1   

SELECT @num=COUNT(*) FROM @t    

WHILE @num>0    

BEGIN            

       SELECT TOP 1 @account= account FROM @t      

        SELECT @account       //取出数据进行操作

        DELETE @t WHERE account=@account          

         SET @num=@num-1    

END