SQL Server XML

I am baffled.  I can do exist(), query(), value() but nodes() is not recognized!  What am I doing wrong? TIA for any ideas. DECLARE @doc XML; SELECT @doc = '<root><data>qwerty</data><data>123456</data></root>'; ...

Is it possible to have the predicate value a variable. Example: DECLARE @XmlData        xml        ,@Predicate      int        ,@Value          nvarchar (65) ...

I'm trying to return a record as xml and storing it into a variable using sql 2000 Can any one help eg declare @A varchar(2000) set @a = (select * from Audit for xml raw) since the select returns one record as a single column containing a ...

Has anyone done any performance testing with updating db records via an xml data type see [link] versus updating with multiple SQL update statements? ...

Hello All, I am having problems extracting xml values from an xml document using XQuery and would appreciate your help. Here is the problem: I am writting a stored procedure to insert data into a table like: create table MyTable table ( ...