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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-17 : 08:30:33
|
| Danny writes "I have a large (28 M) XML packet which I want to put into SQL Server 2000 as a set of tables. All the examples of importing XML I could find specify that the XML is imported as a variable in the stored procedure or command; this means that there is a limit of 8000 bytes for the XML packet. (It is not possible, or I don't know how, to declare the text data type in a stored procedure or command.) The XML packet is in a file that is local to database.I want to do this just in T-SQL, not in ASP, ASPX, C#, etc. I'm using Windows 2000.Any code samples or help would be greatly appreciated.Thanks.Danny" |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-18 : 06:38:14
|
| The XML packet is NTEXT and not VARCHAR isn't it? If so there is no (realworld!) size limit.I can't think that you can get the imput data manipulated using Query Analyser, but I would expect you can using OSQL and a DOS command line prompt.Kristen |
 |
|
|
|
|
|
Importing a large XML file into SQL Server 2000