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)
 Text fields

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-06 : 09:09:17
Mark writes "I've read a number of things on text, ntext, nchar, nvarchar fields but am still confused. I'm pretty new to SQL Server. I'm putting together a SQL Server 2000 database which needs text fields that potentially could hold small notes to multipage documents. The question I have is which field to select if I want to preserve the text formatting. People obviously use hard returns to create new paragraphs, ect..

Also, is there a way to link or embed a Word document directly to/in a SQL record?

I'm using an html form as the interface to the database."

Nazim
A custom title

1408 Posts

Posted - 2002-05-06 : 10:56:10
Mark, why dont u store that in a file seperately and have a column store its path and work your way with code.

Check this site's FAQ on storing images. you will get some useful information.


HTH

--------------------------------------------------------------
Go to Top of Page
   

- Advertisement -