another xml => sql tables question
Thu, 21 Aug 2008 17:47:12 -0400
Still don't understand why simple things don't stay simple ....
I have tons of xml data files.....and xsd's that are not good enough to
create tables out of them....they don't have annotations and field lengths.
I create xsd files out of xml files with SQL 2008's Overdone Not So Simple
Extra Complicated (w ...
|
is it possible to use parameter as the XQuery string in xmlColumn.query()
method?
Thu, 21 Aug 2008 23:26:04 +0800
Hi guys:
select experience.query(N'/root/experience')
from UsersProperties
the code above works, but I want to use parameter to substitue string
literal '/root/experience', like this
declare @query as nvarchar(200)
set @query = N'/root/experience'
select experience.query(@query)
from UsersPro ...
|
Faster search with xquery contains()
Wed, 20 Aug 2008 10:24:02 -0700
Hi
In our work we have a table with 37000 records (aprox). The table have a xml
column, with primary xml index and a secondary path index.
The xml structure is something like this:
<Usuario>
<mbUSR_Usuario>
<tbus_Email>ukel1ele@mail.cl</tbus_Email>
....
....
</mbUSR_Usuario>
</Usuario>
...
|
Annotation question
Tue, 19 Aug 2008 15:37:45 -0400
Hi,
I was wondering if anybody could assist me with annotated XSDs when
attempting to bulkload XML.
Here's the structure of the xml I'm receiving and attempting to load into 2
tables.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Envelope xmlns=http://www.xxxx.com/schema/billofmaterials
xm ...
|
SQL/XML Annotation Question - a different take
Tue, 19 Aug 2008 07:28:08 -0400
So..... we have these files from different vendors in XML to be loaded into
SQL Server.
Looks like they don't have the annotation/relationship sections at the
towards the top of the files.
These are complicated schemas and people who were creating them knew what
they were doing.
Is there another way of "cre ...
|
annotation issue with SQLXML - BulkLoad
Mon, 18 Aug 2008 19:55:36 -0400
"Travis McGee" <travisGatesMcGee@hotmail.com> wrote in message
news:eLS4%23jYAJHA.1228@TK2MSFTNGP02.phx.gbl...
>I am getting "relationship expected on" errors on SQLXML Loading Code when
>I
> am creating the tables and then perhaps adding.inserting the data.
>
> Set oLoad = CreateObject("SQLXMLBulkLoad.SQLXM ...
|
annotation issue with SQLXML
Mon, 18 Aug 2008 19:13:03 -0400
I am getting "relationship expected on" errors on SQLXML Loading Code when I
am creating the tables and then perhaps adding.inserting the data.
These are small files
http://www.HumanGenome.org/data/schema1.xsd
http://www.HumanGenome.org/data/data1.xml
is giving me....relationship expected on 'ING'
and the ...
|
|
|
querying for text in an XML field
Mon, 18 Aug 2008 15:36:49 -0400
Using SQL 2005
I've not much experience with XML and SQL 2005. I have a field of XML
datatype. How do I look for a specific string within the XML field?
Thanks!
...
|
fieldname and field value in a table
Sun, 17 Aug 2008 18:33:46 +0200
Hi
For generating audit reports, I want to populate a sql table with
fieldnames and fieldvalues (converted to varchars) from a table.
Example if my table is
Table Customers:
cust_code cust_name
---------- ----------
'cust1' 'Dupont'
I want to get the folowing table :
...
|
IT Job Guru
Tue, 12 Aug 2008 12:21:47 -0700 (PDT)
Are you looking for a Job in India??? You have experience in Java,
Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a
minute and log on to www.itjobguru.com/forum/index.php. It has all
the
latest Jobs and also the Questions that will be asked in Interviews.
Or are you planning to do a cert ...
|
