Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format
i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.
i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.
10 pts.
I want to load XML to a table in SQL Server 2005
i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.
i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.
SQL server - Stocks Data -How to Push Data To Client Application
My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application...
My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application...
OAB Communications
OAB - 11.5.10 FP K RUP 2 - I'm trying to send a communication, via email, to Participants who have a "gain a child" Life Event. I've Created a System Extract, which ran successfully. I created an RTF Template and merged the extract data into a PDF and ran the Extract Write XML concurrent process...
OAB - 11.5.10 FP K RUP 2 - I'm trying to send a communication, via email, to Participants who have a "gain a child" Life Event. I've Created a System Extract, which ran successfully. I created an RTF Template and merged the extract data into a PDF and ran the Extract Write XML concurrent process...
Looking for good AS400/RPG-XML translator software package
Looking for a good, robust, easy to learn AS400/RPG-XML translator package for importing and exporting from AS400. Recommendations very much appreciated. Thanks, Alex
Looking for a good, robust, easy to learn AS400/RPG-XML translator package for importing and exporting from AS400. Recommendations very much appreciated. Thanks, Alex
Extracting information with a DTS package from a database in SQL Server 2000
We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?
We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?
shredding xml in sql server 2005
In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row> ...
In SQL Server 2005 one shreds XML via the nodes() method. When inserting into a table using this it preforms extremely slowly. If the "into #x" is removed the shredding is very fast. declare @x xml -- there are 1000 rows in the xml document set @xml = ' <rows> <row> ...
Export XML from SQL Server 2000
We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?
We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?
XML and RPG
I do not have the XML toolkit package on my i5 525. We are running V5R4. Is there still a way for me to import XML files and run in RPG ILE? I have a customer that wants to send us orders via email and XML is one of the formats they could provide for us.
I do not have the XML toolkit package on my i5 525. We are running V5R4. Is there still a way for me to import XML files and run in RPG ILE? I have a customer that wants to send us orders via email and XML is one of the formats they could provide for us.
xml create form sql database
i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file
i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file
Enterprise COBOL XML Attributes
I am working on a COBOL XML Application where the XML message needs to have an attribute on the Group Level, with subordinate items generated as Child elements. According to the Enterprise COBOL manuals, it appears that I can choose EITHER format by specifing WITH ATTRIBUTES on the XML GENERATE...
I am working on a COBOL XML Application where the XML message needs to have an attribute on the Group Level, with subordinate items generated as Child elements. According to the Enterprise COBOL manuals, it appears that I can choose EITHER format by specifing WITH ATTRIBUTES on the XML GENERATE...
convert Oracle query into xml file
Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.
Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.
Interfacing from SAP to 3rd party systems
My company is considering outsourcing some HR services to a 3rd party and envisage sending an extract file of HR master data daily. They have expressed the wish to send the filme in xml format what is the most effective way to convert an extract file to xml format. Thanks Graham L
My company is considering outsourcing some HR services to a 3rd party and envisage sending an extract file of HR master data daily. They have expressed the wish to send the filme in xml format what is the most effective way to convert an extract file to xml format. Thanks Graham L
Creating View With Xml file and table in sql server 2005
Hi, I have an Active Directory Xml File and I have archived Table with Active Directory With Limited Information like(GUI,FName, Userid) I like to create a view By left join active directory file and archived table. Thanks for reply in advance Please reply to this question
Hi, I have an Active Directory Xml File and I have archived Table with Active Directory With Limited Information like(GUI,FName, Userid) I like to create a view By left join active directory file and archived table. Thanks for reply in advance Please reply to this question
Exporting stored procedure results into an XML file in SQL Server
I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?
I need to export the result from a stored procedure into an XML file directly in SQL Server. How would I go about doing this?
Input-validate an XML schema file into a Domino page
What is the best way to input-validate an XML schema file into a Domino page?
What is the best way to input-validate an XML schema file into a Domino page?
XML-INTO
I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...
I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...
Retrieving specific XML data in SQL Server
I have a question regarding SQL Server. I have a table with an ntext datatype column where I am storing XML data. My question is: How do I write a user-defined function to retrieve a particular xml attribute in that column?
I have a question regarding SQL Server. I have a table with an ntext datatype column where I am storing XML data. My question is: How do I write a user-defined function to retrieve a particular xml attribute in that column?
How do you create a file containing Simplified Chinese characters (DBCS) and English in the same field on IBM iSeries IFS in UNICODE UTF-8 format?
Caveat - I am not an iSeries programmer(since 15 years ago), so please be very specific with your answer so that I can understand it. I am trying to print product labels with Simplified Chinese characters on a Zebra bar code printer from data retrieved from IBM iSeries (AS/400). The data for the...
Caveat - I am not an iSeries programmer(since 15 years ago), so please be very specific with your answer so that I can understand it. I am trying to print product labels with Simplified Chinese characters on a Zebra bar code printer from data retrieved from IBM iSeries (AS/400). The data for the...
