Where to write XQuery statements?

Where to write XQuery statements?

Hi,

don=B4t 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)& #91;1]','nvarchar(ma
x)')

HTH, Jens Suessmeyer.

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

Jens  wrote:
> Hi,
>
> don=B4t 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)& #91;1]','nvarchar(ma
x)')
>
> 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: 
>
>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