Posted by Shilpa on 11/03/33 11:43

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

• Next in forum: Re: How to fire a trigger without changing table data
• Prev in forum: Re: How to fire a trigger without changing table data
• Thread view: Re: Where to write XQuery statements?

[Reply to this message]