Posted by Jens on 10/09/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
---

[Back to original message]