Dear all,
I'm trying to print a particular value from a Xml string .I have tried this coding but i cant get the o/p can any one help me on this....
the error im getting is
'The parameters supplied for the function "OpenXML" are not valid '
declare @xml_hnd varchar(max)
declare @option_id int
set @xml_hnd='
'
set @option_id =(select option_id from openXML
(@xml_hnd ,'/Newdataset/table',2)
with
( option_id int
))
print @option_id
Thanks.