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 |
|
hennie7863
Starting Member
12 Posts |
 Posted - 2003-05-16 : 11:11:24
|
| Hi,At this moment i'm trying to extract data into a textfile from SQL Server in XML Format (with FOR XML EXPLICIT). When i try to use osql i don't get it right. A lot of CR's and the some comments is included which is not in XML Format. Annoying!As i read in the manual it can't be done with osql and also the query analyzer will cut of lines. What do i need to do. Write a Sproc arround the query and format it in the right way??Help would be appreciated!!!!HennieEdited by - hennie7863 on 05/16/2003 11:15:11 |
|
|
pmr
Starting Member
37 Posts |
Posted - 2003-05-16 : 13:25:32
|
| Are you trying to:Display data in a table on your web page from the database orFormat a full XML page from your database orExport a text file that can be linked to on the website?Peter |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-16 : 20:05:17
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=9336 |
|
|
|
hennie7863
Starting Member
12 Posts |
Posted - 2003-05-19 : 03:33:20
|
| Pmr : I'm Trying to write a XML file with only the data (no (x)html or what so ever). Just data!Rob thx : i think i can use this! R u dutch?Edited by - hennie7863 on 05/19/2003 05:20:34 |
|
|
|
hennie7863
Starting Member
12 Posts |
Posted - 2003-05-19 : 05:24:58
|
| The http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=9336 hint helped and i can create a XML file now. But (always that "but" ;-)) when bcp is creating the xml file the following errors occur :"Serverdata <2152> exceeds host - file length <0 bytes> for field <1> use prefix length, termination string or a larger host file field size. Truncation cannot occur for BCP output files."keh? |
|
|
|
|
|
|
SQL Server and XML