Posted by Jens on 06/19/30 11:43

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

• Next in forum: Re: LDAP authentication for Yellowfin on SQLserver
• Prev in forum: Re: slow insert, logical fragmentation
• Thread view: Re: Where to write XQuery statements?

[Reply to this message]