Where to write XQuery statements?
3  2503 
Hi,
donīt understand your question ? Where you can use it ? For example
you can use it in selecting different nodes from an XML data(type).
EVENTDATA().val ue('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max )')
HTH, Jens Suessmeyer.
--- http://www.sqlserver2005.de
---
Jens wrote: Hi,
donīt understand your question ? Where you can use it ? For example
you can use it in selecting different nodes from an XML data(type).
EVENTDATA().val ue('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max )')
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Hey Jens,
Thanks for the reply
I want to know in which editor would you write the statement?
Can you write it in Query Analyser of SQL Server 2005??
Regards,
Shilpa
On 27 Mar 2006 19:15:33 -0800, Shilpa wrote: Jens wrote: Hi,
donīt understand your question ? Where you can use it ? For example
you can use it in selecting different nodes from an XML data(type).
EVENTDATA().val ue('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max )')
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
Hey Jens,
Thanks for the reply
I want to know in which editor would you write the statement?
Can you write it in Query Analyser of SQL Server 2005??
Regards,
Shilpa
Hi Shilpa,
You can write both your SQL statements and your XQuery statements
anywhere you like - Query Analyser, Management Studio, Word, Notepad,
etc - it doesn't matter.
--
Hugo Kornelis, SQL Server MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tom Corcoran |
last post by:
I am working to ease updating of a html page by transforming 2 xml files. I
was going to use xslt for this and had bought 2 unopened books, wrox xslt
and o'reilly's xslt cookbook. But am now wondering if I am better of
learning XQuery instead?
Any thought and opinions would be appreciated.
Cheers - Tom.
The Architect: "Hope, it is the quintessential human delusion,
|
by: Benjamin G. Jones |
last post by:
I am having a very basic problem with XQuery.
I want to use an XQuery API in Java (either Saxon or Qexo), and I have
an XQuery expression that works as expeced from the command line if I
specify a filename before the xpath expression.
What I want to know is this: If I want to use
Qexo's gnu.xquery.lang.XQuery.eval() or
Saxon's QueryExpression.evaluate(),
how do I specifiy the input in the Xquery statement?
|
by: inquirydog |
last post by:
Can anyone explain to me why the following XQuery expression (a simple
xpath expression) returns a different result than the same expression
in xslt?
document("document.xml")//a/@b
For the following sample document:
<root>
<a b="1" />
|
by: Jeff Kish |
last post by:
Hi.
I see it appears that xquery is case senstitive for looking for particular attribute values etc.
Is there a standard way around this? Say I want to see all nodes with an attribute valued
"copyright" or some such?
Finally, is there a "like" function similar to sql? I perused the docs and did not see anything, but
was wondering if I missed it, or if there is a way around it? Maybe I need to write a user function?
|
by: Clamps |
last post by:
So I've been reading about XQuery, but cannot find a dll or namespace
download to use the technology in vs.net 2002 or 2003. Any directions would
be great.
--
"If I'm the president, we're going to have emergency-room care,
we're going to have gag orders."
---W "The President"
| | |
by: ken_north |
last post by:
A future version of DB2 UDB will support a tighter integration of
XQuery with SQL -- being able to embed XQuery in SQL statements, and
vice-versa.
Dr. Daniela Florescu of the W3C XML Query Working Group suggests an
approach the industry should be taking with XML and XQuery processing:
http://www.webservicessummit.com/People/DFlorescu.htm#DeclarativeXML
Dana departs from the philosophy that XML is a technology for
|
by: Daniel |
last post by:
where does Microsoft.Xml.Xquery live?
where does Microsoft.Xml.Xquery live? all i can find is a copy of it in the
sample project:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvsdev05/html/vs05c5.asp
but would like to know where Microsoft.Xml.Xquery should be obtained.
|
by: Shilpa |
last post by:
Where to write XQuery statements?
For eg:
doc("D:\\workArea\\Books.xml")/Books/Book/Name
|
by: Ale |
last post by:
Hi all!
I need to build a middleware for XQuery: I mean a software receiving a
std xquery and outputting the xquery result on "database.xml".
This middleware must use 7 or 8 different choosable XQuery
implementations... The XQuery received must be std for all
implementations. The middleware will parse the std XQuery in the
specific XQuery for the specific implementation, returning an error if
requested features isn't avaiable for the...
|
by: tammo.mueller |
last post by:
Hi,
I'm trying to execute a xquery statement and I get always errors.
It seems that only the prolog section is giving me errors.
If I want to declare a namespace the xquery processor is coming up with
an "unexpected token" error.
The same error appears if I just set the version.
The xquery statement itself is working without prolog, but I get no
results because of the missing namespace.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
