help with xml schema mapping
Mon, 5 May 2008 14:07:06 -0700 (PDT)
To start off, I'm pretty new to XML. I have a huge XML data file and
would like to import it into SQL 2000. I think I have a workable
schema, but I'm not sure now how to map it to the database table. I
really only want the information in the dli_hdr section. Thanks so
much!
Here is just a small part of th ...
|
Importing XML to Database
Thu, 1 May 2008 12:10:04 -0700
I'm trying to import a pretty simple XML file into a single SQL Server 2000
database table with SQLXML 3.
Here's a snippit of the XML file:
<Account>
<accountname>Smith, Fred</accountname>
<custom3>fredsmith</custom3>
<email>carolz@exgate.tek.com</email>
<computername>EWE126772</computern ...
|
Ahhhhhhhh XML bulk upload
Tue, 29 Apr 2008 09:19:55 -0700 (PDT)
after several issues uploading a simple xml file to SQL i get numerous
errors from SQL about the contained data being wrong.
Question HOW ON EARTH do you log where exactly the incorrect data is
in the XML, i can validate the XML with the XSD fine but its uploading
it to SQL that causes the most problems I just ...
|
Display SQL XML Column
Thu, 24 Apr 2008 06:43:19 -0700
How do I display an SQL XML data type (column) within classic ASP?
Thank you in advance for your assistance. ...
|
xquery -- inserting multiple elements
Tue, 22 Apr 2008 14:45:24 -0700 (PDT)
hey there for anyone familiar with xquery. is it possible to insert
multiple element nodes using the below syntax? A singular item node
works using the "as first" notation, multiple item nodes do not work.
thanks in advance,
Kenny
declare @xml xml
set @xml =
'
<actions>
<item>testing</item>
</act ...
|
request for book review
Thu, 17 Apr 2008 10:26:05 -0700 (PDT)
Can anyone provide a review of an XML book named
Foundations Book II: Understanding SQL Server 2005 Supporting
Technology
(XML, XSLT, XQuery, XPath, MS Schemas, DTD's, Namespaces)
?
There seem to be two versions, one with _2005_ in the title and the
other with _2005-2008_ in the title.
The book is l ...
|
Unable to custom format XML with For XML Explicit
Wed, 16 Apr 2008 06:53:32 -0700 (PDT)
Hi,
Is it possible to format any kind of XML file with the FOR XML
EXPLICIT mode in SQL Server 2005? I am asking because I am trying to
format my file in a way that I could get 2 or 3 elements on my parent
or child level and put some attributes (icon path for example) in
these 2nd element or 3rd element. I am u ...
|
|
|
How to view permissions of existing stored proc ?
Tue, 15 Apr 2008 07:44:16 -0700 (PDT)
Hello,
I am trying to view the permissions granted to various users for a
given stored proc.
I tried "sp_helptext <stored_proc_name>".
I also tried "sp_help <stored_proc_name>"
It did not help
Could somebody help me please ?
This is for SQL Server 2000 - 8.00
Thanks in advance for all help. ...
|
Updating XML documents stored within SQL Server
Tue, 15 Apr 2008 02:43:17 -0700 (PDT)
I have xml documents stored inside sql server. I know how to get back
a piece of data using xquery eg:
select CustomerDocument.query('data(/*:Customer/CustomerInformation/
Name)')
from Customer
where ID = '4747345041'
(This will return Pete)
but i don't know how to change the value. I was expecting some ...
|
sp_xml_preparedocument retrieve
Mon, 14 Apr 2008 08:15:42 -0700 (PDT)
Hi All expert,
a quick question, i have one field type is text, now i need to
retrieve that field value to get some data,
text field contain xml format. However i not able to declare the the
variable >> declare @x text
* my is sql sever 2000
any idea?
declare @x text
select @x = xmlValue from table ...
|
