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

代码
 1 
 2  declare   @name   varchar(20) 
 3  Declare   Cur   Cursor   For   
 4           SELECT Column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'UserLotteryConfig_1')
 5  declare   @SQL   Varchar(2000) 
 6 Open   Cur   
 7 Fetch   Cur   Into   @name 
 8 While   @@FETCH_STATUS=0 
 9 BEGIN 
10             if(@name<>'UserName' And @name<>'BetClassID')
11             Begin
12                 Print @name 
13                 Set   @sql= ' UPDATE UserLotteryConfig_1 SET   '+@name+ '=10000000 where UserName=''host'' ' 
14                 Exec(@sql)
15             END
16             Fetch   Cur   Into   @name 
17 End 
18 Close   Cur 
19 Deallocate   cur