Help me please with length of text filed

i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracte
rs)
from documentations of sql 2000 server i understanded that a field text can
store aboute 2^31-1 caracters. but when i build the insert query with this l
ong data the msde tells me that i try to insert too long data value(permiese
d length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.droptable.comHow are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQ
droptable.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.droptable.com|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.droptable.com|||"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQ
droptable.com...
> insert into table(Column) VALUES('more than 128 caracters')

Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('00000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegroups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length
is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.droptable.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQ
droptable.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.droptable.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>