July 26, 2004 at 1:35 pm
I have a procedure which has a variable of text datatype used within a cursor. Each time the data is accessed from table it gets stored into this text datatype variable. somehow this procedure fails to compile and returns a msg as
Server: Msg 2739, Level 16, State 1, Line 1
The text, ntext, and image data types are invalid for local variables.
any thoughts on this will be greatly appreciated.
TIA
July 26, 2004 at 2:45 pm
The message is pretty clear TEXT VARIABLES ARE NOT ALLOWED as local variables types
All you could use is temptables with text columns
HTH
* Noel
August 4, 2004 at 6:11 am
what about making table and insert wanted Rows in it .. and Give numbers beside it (1,2,3) .. and loop through it ...
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply