Hi,
I am passing a string containing data within xml tags to a Stored Procedure.
I use openxml to populate various tables with the data. In the example below the data value within package is...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20937425.html
VERY URGENT FOR ME
I want to open XML File and store the data in a sql server database
My script work fine if i open a simple xml file. If i open a xml file with a xdr link, my script work bu...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21068932.html
Issue: Xpath containing array index behaves in dissimilar manner when used in OPENXML in Stored Procedures running in SQL Server 2000 installed on Win XP and Win 2k machines.
Description:
A s...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21289757.html
Okay, I like the idea of OpenXml, but how does it determine where the actual document.xml is located to import from???
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21784558.html
Can anyone give me an openxml example of inserting into a SQL table, from an xml file - the caveat is that I am using SQLMobile, so cannot utilize SPROCS at all.
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21847452.html
Zones:
C#Date Answered: 06/09/2006 Grade: A Views: 0
I am trying to insert values using OpenXML to limit calls to my database. This procedure will handle allowed roles for a given user. The values I pass in would be like this:
@userID = 10487
@...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21881251.html
dear All,
Below is the code to retireve data from a XML file. The data which i need to store in DB is "BUS" from line <FormalName Scheme="N2000">BUS</FormalName> and value of ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22410728.html
Hi,
I am facing an error while using openxml in sql server 2000. I am getting a xml string as a text parameter of stored procedure from a C# code.
The xml string that I am getting in parameter is...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22559221.html
When I use the following code, then the five spaces at the right of the 'x' are getting trimmed away. How can I avoid this? I don't want to replace the space with another character (like Chr(160) o...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20122994.html
How do I add a value that is not from my XML doc? For example, I want to put the value 6 in Qty field but it is expecting a Node instead of @num1.
DECLARE @num1 int
SET @num1 = 6
EXEC sp_xml...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20555409.html
Zones:
DatabasesDate Answered: 02/16/2004 Grade: A Views: 4
