通过游标循环遍历表所有字段

 

 declare   @name   varchar(20) 
 Declare   Cur   Cursor   For   
          SELECT Column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'UserLotteryConfig_1')
 declare   @SQL   Varchar(2000) 
Open   Cur   
Fetch   Cur   Into   @name 
While   @@FETCH_STATUS=0 
BEGIN 
            if(@name<>'UserName' And @name<>'BetClassID')
            Begin
                Print @name 
                Set   @sql= ' UPDATE UserLotteryConfig_1 SET   '+@name+ '=10000000 where UserName=''host'' ' 
                Exec(@sql)
            END
            Fetch   Cur   Into   @name 
End 
Close   Cur 
Deallocate   cur