What does the 'N' in 'AS N' mean?
Fri, 10 Oct 2008 11:25:51 +0100
I see a lot of examples of adding schemas to the schema collection that
start with:
CREATE XML SCHEMA COLLECTION BookIndex
AS N'<xs:schema attributeFormDefault="unqualified"...
What's the 'N' affter the 'AS' for? What does it mean?
...
|
Query question
Wed, 1 Oct 2008 08:57:02 -0700
Why doesn't this work?
DECLARE @x XML
SELECT @x = '
<OnlineResponse xmlns="http://www.myURL.com/schema/online" version="1.0"
message="Valid Format"></OnlineResponse>'
SELECT @x.query('data(OnlineResponse/@message)') AS message
But if you remove the xmlns attribute from the XML, it works. ...
|
Simple XML column Query Question?
Tue, 30 Sep 2008 14:35:48 -0700 (PDT)
I have an XML column that contains multiple records and am looking for
a way to get all of the values using a.value like query. Below is some
TSQL that illustrates my question. Thanks for checking this out.
-------------------------------------------------------------------------------------------------------- ...
|
Xml newbie question
Sun, 28 Sep 2008 09:29:00 -0700
Hi,
A field in my db table has an xml field that holds something like this...
<Root>
<Feed id="27 Sep 2008 16:15:28:560">
<Content>some content here</Content>
</Feed>
<Feed id="28 Sep 2008 16:15:29:230">
<Content>some content here</Content>
</Feed>
</Root>
I would like to execute a command from with ...
|
combine multiple replace of value statements into a single update statement?
Fri, 26 Sep 2008 19:17:26 -0400
I have the following code that has 3 replace of value statements in 3
different sql update statements. What I need to do is combine all 3 replace
of value statements into a single update statement since all 3 values deal
with the same xml column. What would the new code be?
begin transaction;
update [News]. ...
|
Can't insert xml into xml column even when schema is followed?
Wed, 24 Sep 2008 19:21:17 -0400
I have the following sql statement that is supposed to insert the xml into
the xml column:
insert into [News].[News](Article) values ('<NewsArticle Title="test 1"
Date="09/05/2008T12:00 PM"><Description>This is the article
description</description><Body>This is the article
body</Body></NewsArticle>')
...
|
XSD schema SQL Server Profiler exports
Wed, 24 Sep 2008 15:38:00 -0700
Hi,
After taking a trace with SQL Server Profiler, it is possible to export the
results of the trace to an XML file. Now I would like to write my own
analyzer tool in .NET, but I need the XSD schema for these XML files. Can
anyone provide me that or tell me where to find it?
Regards,
Bjorn ...
|
|
|
How to setup a HTTP XMLA data pump for SQL2008
Tue, 23 Sep 2008 00:47:00 -0700
Hi
Setting up a XMLA datapump in SQL2005 is well described in the "Configuring
HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server
2003" white paper at
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
How do you setup http xmla access for SQL2008 ...
|
xml datatype in sqlserver2005
Mon, 15 Sep 2008 02:48:42 -0700 (PDT)
Hi,
I have a XML stored in a column of datatype xml.
i need to return the the xml on selecting the row .
i am using java,jdbc for creating the connection amd fetching the
values.
but my xml is returned as string i need to do xml transformation for
showing it the user.
how can i do xml -xslt transformation... ...
|
SharePoint Error with SQL Server Unable to serialize the session s
Sun, 14 Sep 2008 23:29:01 -0700
Hello,
I'm no developer so I need your help ASAP my Purchase Request system is down
and eveyone is looking at me.
1. Windows 2003 Standard
2. MOSS 2007
3. 2 Front end servers
4. One SQL DB Server
5. Microsoft Dynamics GP Business Portal is connected.
6. Perfromed Windows Update two days ago on all ...
|
