Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to update a text field from a file
I decided to use WRITETEXT instead of UPDATETEXT because of http://msdn.microsoft.com/en-us/library/aa260658%28v=sql.80%29.aspx (the very first paragraph): ... Use UPDATETEXT to change only a portion of a text, ntext, or image column in place. Use WRITETEXT to update and replace an entire text...- PontiacCZ
- Post #3
- Forum: Microsoft SQL Server: Programming
-
how to update a text field from a file
Hello, I am trying to load a text file (HTML actually) and replace already existing table field (of "text" data type) with this file's content. SQL server: 8.0 (SQL 2000 standard) table: KART_CUSTOMERS column: Data input file: C:\temp\input.html With help of web resources I was able to...- PontiacCZ
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
