孤城浪子的地盘

declare @a int;
declare @iddd int;
declare @itemp varchar(8000);
set @a=11;
while @a<=8503
begin

SELECT @itemp =CONTENT  FROM  ARTICLE where idid=@a;

SELECT  @itemp = CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:variable("@itemp"))', 'VARBINARY(MAX)') AS VARCHAR(MAX) );

update ARTICLE set [CONTENT]=@itemp where idid=@a;
set @a=@a+1;
end