declare @Ptr varbinary(16)declare @table table (t text)select @Ptr=textptr(testText)
from adeclare @tmp varchar(8000)
select @tmp=t from @table
updatetext a.ptext @Ptr 0 null @tmp
from adeclare @tmp varchar(8000)
select @tmp=t from @table
updatetext a.ptext @Ptr 0 null @tmp
create proc p_test
@a text
as
select datalength(@a)
goexec p_test 'abc'