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