SQL ntext字段的替换方法
复制CREATE procedure [dbo].[Proc_UpdateNTextField] @TargetTable nvarchar(1000),字段 --目标表名 @TargetField nvarchar(1000), --目标字段名 @PKField nvarchar(1000), --该表主键字段名 @otxt nvarchar(1000), --需要替换的字符串 @ntxt nvarchar(1000) --替换后的b2b供应网字符串 as begin declare @SqlStr nvarchar(4000) set @SqlStr = declare @txtlen int set @SqlStr = @SqlStr + set @txtlen = len( + @otxt + ) set @SqlStr = @SqlStr + declare @pos int set @SqlStr = @SqlStr + set @pos = 0 set @SqlStr = @SqlStr + declare curs cursor local fast_forward for select set @SqlStr = @SqlStr + @PKField + , textptr( + @TargetField +) from + @TargetTable + where + @TargetField + like % + @otxt +% set @SqlStr = @SqlStr + declare @ptr binary(16) set @SqlStr = @SqlStr + declare @id char(32) set @SqlStr = @SqlStr + open curs set @SqlStr = @SqlStr + fetch next from curs into @id, @ptr set @SqlStr = @SqlStr + while @@fetch_status = 0 set @SqlStr = @SqlStr + begin set @SqlStr = @SqlStr + select @pos= patindex(% + @otxt + %,ProductDesc) from ProductTemp where ProductID=@id set @SqlStr = @SqlStr + while @pos>0 set @SqlStr = @SqlStr + begin set @SqlStr = @SqlStr + set @pos=@pos-1 set @SqlStr = @SqlStr + updatetext + @TargetTable + . +@TargetField + @ptr @pos @txtlen + @ntxt + set @SqlStr = @SqlStr + select @pos= patindex(% + @otxt + %,ProductDesc) from ProductTemp where ProductID=@id set @SqlStr = @SqlStr + end set @SqlStr = @SqlStr + fetch next from curs into @id, @ptr set @SqlStr = @SqlStr + end set @SqlStr = @SqlStr + close curs set @SqlStr = @SqlStr + deallocate curs EXECUTE sp_executesql @SqlStr end 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.源码库
本文地址：http://www.bzve.cn/news/577b8099342.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。