hi
i need to store data more than 8000 char in varchar in sql server 2000
how can i? plz help.

hi friends :)
for this use "ntext" datatype.
Here u will see 1 bit probl. like u need to insert data from insert query only. and can read from select query. U cant using return all row.. etc.
Enjoy Coding. . Bye

SOlving question asked by yourself? Odd...

SOlving question asked by yourself? Odd...

There are actually people around here that do like to search for the answer and if they find it they will post it. Only waiting to get your question answered is waste of time...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.