https://www.gclz.cn/index.php zh-cn https://www.gclz.cn/post// 孤城浪子 <admin@yourname.com> Thu, 23 Jan 2014 17:12:02 +0000 https://www.gclz.cn/post// 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

Tags - sql ]]> https://www.gclz.cn/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://www.gclz.cn/post//#blogcomment