|
Home > Archive > Microsoft SQL Server forum > March 2006 > Where to write XQuery statements?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Where to write XQuery statements?
|
|
| Shilpa 2006-03-27, 7:37 am |
| 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
---
| |
| Shilpa 2006-03-28, 3:27 am |
| 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
| |
| Hugo Kornelis 2006-03-28, 1:29 pm |
| 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
|
|
|
|
|