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.
| Author |
Topic |
|
requestor
Starting Member
17 Posts |
 Posted - 2007-10-24 : 00:28:18
|
| Hai, i need ur suggestion to use ntext in my table. basically i want to store the xml data(will be in same xml format only) in sql2000 database. the max size of the data will be 5mb. so can i use ntext to store this data.basically, only once i insert the data to the database. no update after that. only i throw the query to retrieve that xml data from the database. is it advisable to use,ntext for this requirment. is there any other suggestion ??help pls |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-24 : 03:07:09
|
| Ntext is fine. Particuarly if your XML doc is going to be greater than 8000 characters.I assume you are going to use OPENXML to read from the Ntext column . If you know your document is going to be less tha than 8000 characters , the alternative is to store the XML in a file and read it into the Stored procedure when you need to processJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-24 : 21:54:28
|
| Or use taxt type if don't have unicode data. |
|
|
|
|
|
|
suggestion abt using ntext