有关ntext的存储过程 急!高手请进,在线等待....
我要将一个表中的某些记录插入到该表中,但ntext不能用中间变量插入进去,如下存储过程:
declare @type as nvarchar(20),@typetime as smalldatetime,@content as ntext
declare Insert_cursor scroll cursor
for
select [type],[typename],[typetime],[content] from [content] where [uid]=999999999
open Insert_cursor
select @i=1
while @i<=@@cursor_rows
begin
fetch next from Insert_cursor
into @type,@typename,@typetime,@content
insert into [web_module].[dbo].[type]([type],[typename],[typetime],[content])
values(@type,@typename,@typetime,@content)
select @i=@i+1
end
close Insert_cursor
deallocate Insert_cursor
[content]类型为ntext 但系统报告不能用ntext,image等类型进行等,有什么办法,请高手指点!!!