Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  using VALUE and NODES methoda of XML datatype

Author  Topic  ramya.k Starting Member 4 Posts Posted - 2008-06-11 : 00:06:48 Hi I am working on XML datatype(storing data in xml datatype column and retrieving the data)---i am facing a problem in retrieving data using VALUE and NODES methods of xml datatype.i am getting the below error : Msg 2389, Level 16, State 1, Line 1 XQuery [Employee_Attr1.OtherInfo.value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xs:int *' Can some one please help me by providing an example regarding its usage and also some understanding about the NODES method. Thank You.