Posted by Hugo Kornelis on 10/02/43 11:43

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

[Back to original message]