sql server - Get an processing instruction value -

sql server - Get an processing instruction value -

how can value of processing instruction tag in sql server?

declare @x xml = '<root> <entity> <?ent lookups?> </entity> <entity> <?ent staff?> </entity> <entity> <?ent sir?> </entity> </root>'; select x.xml.value('processing-instruction(ent)[1]','varchar(30)') @x.nodes('/root/entity') x(xml);

the select statement returns error: msg 2225, level 16, state 1, line 29 xquery [value()]: string literal expected

you need double-quotes around "ent":

select x.xml.value('data(processing-instruction("ent")[1])','varchar(30)') @x.nodes('/root/entity') x(xml);

sql-server xml