March 18, 2005 at 11:54 pm
Hi,
I have a table
tblmessage
---------------
id integer,
message ntext
Iam retrieving the message from tbl message in this way.
----------------------------------------------
DECLARE @ptrval binary(16), @i int,@Messageid int
set @i=0
SELECT @ptrval = TEXTPTR(text)FROM TblMessage where id=60
set @i=(select DATALENGTH(text) from TblMessage where id=60)/2
READTEXT TblMessage.text @ptrval 0 @i
It is working ...
But I want to store this value in some variable so that I can use in other procedure
exec sp_mail id,message<-----------Now problem is how to pass this variable in this procedure. Thanks in advance..
BhatiaWorld
sanians.com
March 21, 2005 at 6:32 am
Check this out for some tips.
http://www.windowsitpro.com/Article/ArticleID/26244/26244.html
HTH
Marty
March 21, 2005 at 1:14 pm
You can have ntext input variables to procedures, and that should be all you need. Note that you can't declare ntext variables at private (internal to the procedure), they must be input variables.
create proc #test_ntext
@ntext ntext output--optionally can be output as well
as
begin
select @nText
end
Signature is NULL
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply