May 31, 2002 at 9:59 am
I have SQL 7.0.
I would like to declare a variable as a text field if it's possible. If it is possible how do you do it? When I tried to use "DECLARE @email text" it said "The text, ntext, and image data types are invalid for local variables".
If it's not then I would like to find out why when I delcare something as a varchar(7999) it only will let it get as big as 255 characters instead of 7999 characters.
Here is how I'm trying to use it:
DECLARE @email varchar(7999)
SELECT @email='' select @email=@email+database.dbo.table.email+';'
FROM database.dbo.table
May 31, 2002 at 10:20 am
Are you running your query from QA?
If it is a case you should change settings on a menu:
Query-Current Connection Option on Advanced Tab - Maximum Characters per column.
Set it to the max so you would retrieve the correct value without cutting it off
May 31, 2002 at 10:38 am
quote:
If it's not then I would like to find out why when I delcare something as a varchar(7999) it only will let it get as big as 255 characters instead of 7999 characters.
The reason is a text data type is a pointer to the memory address in which the data resides. Varchar is the actual data itself.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 31, 2002 at 11:34 am
I'm using this in a step within a job. So when I use the varchar why is it I can't get the length to 7999?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy