sql server text类型替换

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- 时间:2009-01-06
-- 内容:修改?改为空
-- =============================================
alter PROCEDURE  pro_TabelUp

AS
declare @index int
set @index=58
while(@index< 149)
begin
UPDATE   NewsList  
SET   NewsListContent=replace(cast(NewsListContent as varchar(max)),'?','')
where NewsListID=@index
set @index=@index+1
END
GO

 

原文地址:https://www.cnblogs.com/freexiaoyu/p/1370192.html