MCQs>IT & Programming>Microsoft SQL Server>You are querying a table that contains a field with the data type XML and need only rows that have a particular value in the XML data. Which of the following would not result in an error
Microsoft SQL Server MCQs
You are querying a table that contains a field with the data type XML and need only rows that have a particular value in the XML data. Which of the following would not result in an error
Answer
Correct Answer: SELECT * FROM #table1 WHERE xml_field1.value('(/PageContent/Text)[1]', 'varchar(100)') LIKE '%smith%'
Explanation:
Note: This Question is unanswered, help us to find answer for this one