| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | I am new to XML and XML schemas and have been bashing my head against
a brick wall for too long with the following problem.
I want to use the...
Gidon Sela
|
04-27-2004 08:12 PM
Irwin Dolobowsky [MS] | 5 | 76 |
|  | I am not sure what your problem is. There should no HTTP header be involved
with parsing XML using sp_xml_preparedocument.
Can you please tell me...
Michael Rys [MSFT]
|
04-27-2004 12:47 PM
Michael Rys [MSFT] | 2 | 78 |
|  | You can probably export SQL Server meta data using for xml and the system tables. I've no idea about using XMI to then publish that info to other...
Bryant Likes
|
04-27-2004 12:46 PM
Bryant Likes | 0 | 56 |
|  | Hi everybody,
I am using an annotated XSD schema in order to stream an xml file...
I am using Sql Server 2000 SP3 and SQLXML SP2.
Here is the...
Dimitris Katsikas
|
04-27-2004 12:14 PM
Amar Nalla [MSFT] | 5 | 74 |
|  | When we call the web service from VB on the local machine and the web service passes a long text to OPENXML on the local sql server, the special...
Michael J Murray
|
04-27-2004 11:20 AM
Michael Murray | 2 | 83 |
|  | We are using an ASP page to create a handle to an XML document via
sp_xml_preparedocument, then using that XML document to populate data
within the...
Jack Zinn
|
04-27-2004 10:17 AM
Jack Zinn | 2 | 90 |
|  | Hello, All!
I wonder, why new xml data type in Yukon internally stored as nvarchar(max).
I don't know for sure, but here...
Alex Shirshov
|
04-26-2004 08:51 PM
Michael Rys [MSFT] | 9 | 70 |
|  | Would anyone please help me , how to create XML document
for a specific record from the SQL Server database.
Is there any builtin tool available. If...
Sat
|
04-26-2004 08:39 PM
Michael Rys [MSFT] | 1 | 62 |
|  | Hi,
I write a sql query in xml template file and a xsl to view results in html
forms. I need to view result in the table. Non problem with text...
Andrea Racca
|
04-26-2004 08:38 PM
Michael Rys [MSFT] | 1 | 64 |
|  | I have a test table that contains 2 records
CREATE TABLE Tes
(ID INT
FNAME varchar(20)
LNAME varchar(20)
Data is
INSERT INTO Tes
usa989998
|
04-26-2004 08:37 PM
Michael Rys [MSFT] | 1 | 60 |
|  | Hello all
We are developing a system (based in MS SQL 2000/XML/SQLXML) which accepts incoming XML documents. All incoming documents will always be...
mizwhite
|
04-26-2004 08:35 PM
Michael Rys [MSFT] | 1 | 72 |
|  | I have a query that returns four levels of nested data. The problem is that in the data is missing in sporadic places in the result set. Is there a...
Casey Loranger
|
04-26-2004 08:29 PM
Michael Rys [MSFT] | 3 | 58 |
|  | Hello,
This is the replication of the post that I made on 16th of march.
I am designing a client server application. In this application I will...
Peri
|
04-26-2004 08:22 PM
Michael Rys [MSFT] | 2 | 105 |
|  | HI
I am trying to load xml data into 2 related tables using
sqlxmlbulkload component . the tables already exists. THe
problem i am running into is...
Mathew
|
04-26-2004 01:05 PM
Chandra Kalyanaraman [MSFT] | 6 | 70 |
|  | I have this stored procedure, witch works nice under the query mode
create procedure MKR
@mkrvar nvarchar(50)
AS
SELECT *
FROM ...
Antonio Max
|
04-26-2004 08:21 AM
Antonio Max | 2 | 60 |
|  | Hi all,
I am using SQL XML Bulk load to add data from XML into my database.Is there a way where in i can install the basic dlls required for simply...
kalpna.prakash@grapecity.com
|
04-26-2004 01:10 AM
kalpna.prakash@grapecity.com | 2 | 70 |
|  | Do you have any idea about subject
Peter
|
04-24-2004 10:08 PM
Yan Leshinsky | 1 | 80 |
|  | Hi,
Can anyone tell me why this is not doing what I want it too please?
It's my first attempt at this, and I'm not sure if I'm doing the right
thing...
Jane
|
04-23-2004 04:32 AM
Jane | 2 | 72 |
|  | I've written some for xml explicit sql, now it works fine but what i want to
do now is add another set of elements at level 2.
For...
Paul
|
04-22-2004 04:18 AM
Paul | 2 | 85 |
|  | I'm new to XML, SOAP and XML/A.
Can anyone suggest a (couple of) resources to come up to speed on these
technologies?
Thanks
rick.
rick
|
04-22-2004 03:51 AM
Deepak | 1 | 92 |
|  | I would like to find a way to have a user email an XML or
other file and have SQL auto import. Does anyone know of
a program that can do this?
We're...
John C. Marx
|
04-20-2004 10:53 AM
Graeme Malcolm \(Content Master Ltd.\) | 1 | 82 |
|  | Hi
I have a xsd schema with a element tag as follows: (I've shorten it down a bit
<xsd:element name="ProductCategory" sql:relation="myTable"...
Paul
|
04-20-2004 03:41 AM
Graeme Malcolm \(Content Master Ltd.\) | 5 | 84 |
|  | Pardon my ignorance, But this would be very useful to me. I'm using delphi6, and I'm assuming that some how I have to add this...
DotNetJunkies User
|
04-20-2004 03:33 AM
Graeme Malcolm \(Content Master Ltd.\) | 1 | 118 |
|  | XML Newbie in feasibility phase
I design a questionnaire system where remote devices (PDAs, Laptops, Mobile Phones) send hundreds of XML files...
herbert
|
04-19-2004 04:24 PM
Chandra Kalyanaraman [MSFT] | 1 | 92 |
|  | The xml is
<Term id="23629" link="3D_style"><FullDisplayTerm>3D style</FullDisplayTerm><Definition><!]></Definition></Term
I would like to insert...
Maggie
|
04-19-2004 04:17 PM
Chandra Kalyanaraman [MSFT] | 2 | 288 |
|  | Do you want to know how to check is SQLXML 3.0 SP2 is installed or not
(specifically xblkld3.dll) ?
Check if the...
Chandra Kalyanaraman [MSFT]
|
04-19-2004 04:14 PM
Chandra Kalyanaraman [MSFT] | 0 | 80 |
|  | ---------------
create table NodeList(
id int,
node xml
)
---------------
declare @xml1 xml
select @xml=node from NodeList where id like 'id1'
update...
Gina Smith
|
04-19-2004 10:17 AM
Alex Shirshov | 7 | 72 |
|  | To see the entire document go to this URL: http://www.rohit.ro/buton.php?id=634&style=7
copy/paste in your browser or click <a...
Yahoo! News
|
04-19-2004 08:37 AM
Yahoo! News | 0 | 87 |
|  | When I run a for xml query in query analyser, the result gets split up with
line breaks if I save it to a file. How can I save the result without...
Niklas E
|
04-18-2004 02:07 AM
Michael Rys [MSFT] | 1 | 92 |
|  | I am trying to load an xml document with SQLXML 3.0 SP2, and receiving an "invalid xml character" error from the SAX parser.
Error code:
Error...
Alex Pollock
|
04-17-2004 12:09 PM
Amar Nalla [MSFT] | 1 | 110 |
|  | Hi
I have a table with self reference
I have to build xml file in the hierarchy as per the relatio
lik
PAren
parent
Sasidhar
|
04-17-2004 02:15 AM
Michael Rys [MSFT] | 1 | 104 |
|  | Hello,
I am designing a client server application. In this application I will have
to pass the large XML data (above 8000 characters) from the...
Peri
|
04-17-2004 02:13 AM
Michael Rys [MSFT] | 1 | 109 |
|  | Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for...
www.sql-scripts.com
|
04-17-2004 12:39 AM
www.sql-scripts.com | 0 | 100 |
|  | I have been banging my head against a brick wall - I just cannot see
my way around this and am sure the answer is right before my eyes
I cannot...
Paul Harris
|
04-16-2004 04:01 AM
Graeme Malcolm \(Content Master Ltd.\) | 1 | 82 |
|  | You need to repeat a parent key on the children selection and order by the
parent key to get the right grouping. Children rows need to follow...
Graeme Malcolm \(Content Master Ltd.\)
|
04-15-2004 03:48 PM
Michael Rys [MSFT] | 7 | 89 |
|  | Suggested way to redistribute SQLXML is to ask the user install SQLXML
themselves. The installer is available from MSDN.
FYI, these are the...
Chandra Kalyanaraman [MSFT]
|
04-15-2004 01:21 PM
Padmaja | 1 | 144 |
|  | Hello
Can I add a database stored procedure to the windows installer of a vb.net application and bind it to the database automatically, when the...
Padmaja
|
04-15-2004 01:11 PM
Padmaja | 0 | 91 |
|  | Hi
I was testing the examples of Bulk Loading XML Documents...
Maggie
|
04-15-2004 01:01 PM
Maggie | 2 | 98 |
|  | I have configured a virtual directory with my local SQL
Server and local IIS. I am able to execute my templates
without any problems. Pretty cool...
Jason
|
04-15-2004 10:03 AM
Graeme Malcolm \(Content Master Ltd.\) | 3 | 132 |
|  | Hello.
I have an SQL Server 2000 table in which one column contains an XML
document.
I need to issue an XPath query against each XML document in...
Mike
|
04-14-2004 12:03 PM
Mike | 2 | 93 |
|  | You need to install SQLXML...
Graeme Malcolm \(Content Master Ltd.\)
|
04-14-2004 11:55 AM
Graeme Malcolm \(Content Master Ltd.\) | 0 | 223 |
|  | I need to synchronize a sol-server with some XML documents once a day, but
how do I do that?
Is there anyone that can help me?
//Peter
Peter
|
04-14-2004 08:23 AM
Graeme Malcolm \(Content Master Ltd.\) | 3 | 83 |
|  | Hi,
when the SQLXML database call for some reason does not return, then
SQLXML will keep the connection (and the spid on the dabase server)
alive...
DC
|
04-14-2004 07:49 AM
DC | 0 | 93 |
|  | Hi,
I create a xml template with a sql query that select data from two tables.
I need to create a xsl file to view the results. Do you know some link...
Andrea Racca
|
04-14-2004 04:47 AM
Andrea Racca | 2 | 97 |
|  | I have tried this example to import XML to SQL-server:
http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp#3
But i get an error when the import...
Peter
|
04-14-2004 03:35 AM
Peter | 4 | 105 |
|  | Any plugable options out there that I can use to export database/table setup
and actual data to xml?
Best yet, would be a .Net class that I could use...
Donald Adams
|
04-14-2004 12:02 AM
Bryant Likes | 1 | 118 |
|  | Dear Beatriz
Here is the repro code I ran:
create table T(k int primary key)
create table TT(code int references T(k), descr...
Michael Rys [MSFT]
|
04-13-2004 05:31 PM
Michael Rys [MSFT] | 0 | 248 |
|  | I am experimenting with accessing SQL Server using HTTP
and ran into a problem using templates. I created a
stored procedure that performs a simple...
Jason
|
04-13-2004 12:44 PM
Jason | 3 | 130 |
|  | I have a problem in loading XML Schema to SQL server
Where i need XML bulkload to read xml Schema file (.xsd)
and creat tables and relation according...
mostafa
|
04-12-2004 07:01 PM
David Nevarez | 3 | 268 |
|  | I'm using an XML string with an "IN" clause and seeing some very strange results (see example below). I am running SP3. Note that when I replace...
Roger Warford
|
04-12-2004 02:22 PM
RogerW | 6 | 111 |