Last post Feb 06, 2009 05:04 AM by jrdeveloper
Feb 04, 2009 07:14 AM|jrdeveloper|LINK
Im trying to create stored procedure for search.
Here xml_content datatype is XML.
Getting this error : Argument data type xml is invalid for argument 1 of like function
Msg 8116, Level 16, State 1, Procedure usp_SearchLiveContent, Line 15
Argument data type xml is invalid for argument 1 of like function.
Can anyone help how to solve this?
Feb 04, 2009 10:07 AM|jrdeveloper|LINK
Any one plz?
Feb 04, 2009 10:13 AM|Naom|LINK
You can not use LIKE with XML data type. You need to use XQuery instead. Just google on XML data type to see how to use it.
Feb 06, 2009 05:04 AM|jrdeveloper|LINK