Actually, you can use them as receiving parameter variables; you just can't
declare them within the stored proc (after the AS)

Trevor

-----Original Message-----
From: MILIND AMIN /TECPRO/L-PAREL
[mailto:mssqldba-ezmlmshield-x87714881.[Email address protected]
Sent: Friday, December 29, 2006 4:33 AM
To: LazyDBA Discussion
Subject: RE: SQL Server - stoted procedure using text data type

Hi!,

You can't use text, ntext, and image data types for the
local variables.

What is the reason of using this data type in local
variable?? let us know the reason in detail so will give you
the proper solution.

If you have big string then use Varchar(8000).

Regards,
Milind Amin
Software Professional
TechProcess Solution Ltd
Direct: +91-22-66528612 (M-F Firstly)
Cell: +91-9819916106 (M-S Secondly)
------------------------------------
TEAMWORK...
Coming together is a beginning;
Keeping together is progress;
Working together is a success;
-------------------------------------


-----Original Message-----
From: gopal
[mailto:mssqldba-ezmlmshield-x42758640.[Email address protected]
om]
Sent: Thursday, December 28, 2006 9:03 PM
To: LazyDBA Discussion
Subject: SQL Server - stoted procedure using text data type




Hi all,

i have used to text datatype in stored procedure.

but i am getting this error:

The text, ntext, and image data types are invalid for local
variables.


Code :

CREATE PROCEDURE USP_GetBidBondInformatiom
@BidBondNo int
as
Declare @Bbd_BidBondNo int
Declare @Bbd_RequestDate varchar(75)
Declare @Bbd_Hold ntext


how to awoid this error?

plz help me

thanks & regards
gopalan mani



------------------------------------------------------------
---------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST
REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

--


"This e-mail message may contain confidential, proprietary or legally
privileged information. It
should not be used by anyone who is not the original intended recipient. If
you have erroneously
received this message, please delete it immediately and notify the sender.
The recipient
acknowledges that ICICI Bank or its subsidiaries and associated companies,
(collectively "ICICI
Group"), are unable to exercise control or ensure or guarantee the integrity
of/over the contents of the information contained in e-mail transmissions
and further acknowledges that any views
expressed in this message are those of the individual sender and no binding
nature of the message shall be implied or assumed unless the sender does so
expressly with due authority of ICICI Group.Before opening any attachments
please check them for viruses and defects."




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page