declare @p varbinary(16)
DECLARE @temp NVARCHAR(MAX);
DECLARE @temp1 NVARCHAR(MAX);
DECLARE @temp2 NVARCHAR(MAX);
DECLARE @temp3 NVARCHAR(MAX);
DECLARE @temp4 NVARCHAR(MAX);
DECLARE @temp5 NVARCHAR(MAX);
DECLARE @temp6 NVARCHAR(MAX);
select @temp1 =‘小于8000的字节’
select @temp2 =‘小于8000的字节’
select @temp3 =‘小于8000的字节’
select @temp4 =‘小于8000的字节’
select @temp5 =‘小于8000的字节’
select @temp6=‘小于8000的字节’
create table #tb(aa NTEXT)
insert into #tb select @temp1
insert into #tb select @temp2
SELECT @p=textptr([Content]) FROM Information WHERE (Title = '一层窗口电话')
UPDATE Information set [Content]='' WHERE (Title = '一层窗口电话')
declare p_temp cursor for select aa FROM #tb
open p_temp
fetch next from p_temp into @temp
while @@Fetch_Status=0
begin
updatetext Information.[content] @p null 0 @temp --NULL为尾部追加,0为头部追加
fetch next from p_temp into @temp
end
close p_temp
deallocate p_temp
DROP TABLE #tb