By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Where to write XQuery statements?

P: n/a
Where to write XQuery statements?

Mar 27 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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().value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max)')

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Mar 27 '06 #2

P: n/a
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().value('(/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

Mar 28 '06 #3

P: n/a
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().value('(/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
Mar 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.