SET TEXTSIZE 8000 select top 1 @content=content from document order by id descordeclare @content varbinary(16)select @content=textptr(content) from document READTEXT pub_info.pr_info @val 1 10 order by id desctext 类型是数据流型,不能直接赋值,如果数据量不大,可改为varchar
select @content=textptr(content) from document READTEXT document.content @val 1 10 order by id desc
select @content=textptr(content) from document where id= .. READTEXT document.content @val 1 10
SET TEXTSIZE 8000
select top 1 @content=content from document order by id descordeclare @content varbinary(16)select @content=textptr(content) from document READTEXT pub_info.pr_info @val 1 10
order by id desctext 类型是数据流型,不能直接赋值,如果数据量不大,可改为varchar
order by id desc