Where to write XQuery statements?

[Shilpa]

Where to write XQuery statements?

[Jens]

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
---

[Shilpa]

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

[Hugo Kornelis]

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