Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Inserting large volumes of data

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-09 : 11:14:06
Smita writes "Hi..When i try and insert say about one page of a word document into my table field through an insert query in the query analyser the display of data when i do a select is chaotic. It overlaps and the entire data does not show.
Since the data size is large, i read that the Datatype 'text' is appropriate and is capable of storing even large text files. But when i tried the same thing happened the data overlaps.
I also tried using varchar with a size of 8000 but to no success.
Can u help me on this one.
I basically want to generate the content of my web pages from the database since the number of pages involved runs into hundreds...and if i can do this by picking up the data from the databse it will save me a whole lot of trouble making each page.
Please help me :)"
   

- Advertisement -