SQL Server Loop table

CREATE TABLEDbo.[User](UIDBIGINT IDENTITY, NameVARCHAR( -) not NULL, PWDVARCHAR( -) not NULL ,CONSTRAINTPk_userPRIMARY KEY CLUSTERED(UID)) on [PRIMARY]

--Method 2: Use Table variables--declaring table VariablesDECLARE @temp TABLE(UIDBIGINT, NameVARCHAR( -), PwdVARCHAR( -));--inserting data from a source table into a table variableINSERT  into @temp(UID, Name, PWD)SELECTUid,name,pwd from [User]ORDER  byUID;--declaring VariablesDECLARE    @UID  as BIGINT,    @Name  as VARCHAR( -),    @Pwd  as VARCHAR( -);  while EXISTS(SELECTUid from @temp)BEGIN    --unordered heap Top1 has index TOP1 SET ROWCOUNT 1 No difference    SELECT Top 1 @UID=Uid@Name=Name,@Pwd=Pwd from @temp; --SELECT @UID, @Name, @Pwd    PRINT 'PRIMARY Key'+ cast(@UID  as varchar( -))+'User name'+@Name+'Password'+@Pwd   --SET ROWCOUNT 0    DELETE  from @temp WHEREUid=@UID;END

SQL Server Loop table