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)
 SQL 2000 text Fields and why is it so hard to insert text

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-23 : 10:54:06
John writes "I have a database that has a column that is of type text and is going to just hold large amounts of text. The interface is going to be through ASP so I need to use VBscript to insert the text into this column. For the life of me I can't figure out how to insert text into this column. I've tried to figure out the append chunk to no avail. Does any one have a simple example code that shows how to make this work? If you do that would be great. I don't understand why Microsoft makes it so hard to work with these field types. Its easy as a memo field in access. Oh well. Thanks for your help."

dsetzer
Starting Member

31 Posts

Posted - 2001-12-13 : 10:38:59
Graz, I have read your article. You stated that you inserted a large amount of data into a text field, but, you didn't say anything about how you did it.

Do you need to do anything special with INSERT statements when inserting into a NTEXT field?

Any help is greatly appreciated.
Go to Top of Page
   

- Advertisement -