SQL Server Performance

XMLQuery on NVARCHAR MAX column using filter

Discussion in 'SQL Server 2005 General Developer Questions' started by s_chilkury, Aug 15, 2014.

  1. s_chilkury New Member

    I've a table with ID & MSG columns. ID is unique identifier & msg is NVARCHAR MAX.

    abc><poc><tna name="a" value="abc" /><tna name="b" value="def" /><tna name="c" value="xyz" /></poc></abc>

    I need to find the value "def" from <tna> tag whose Name = "b" based on the ID [where clause].

    This is a huge table. Need to consider the performance as well.

Share This Page