<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a stored procedure with a param @culture char(5)<br />
<br />
How do I use that param in an xquery modify delete statement?<br />
<br />
DECLARE @modified xml<br />
.... additional code setting the @modified<br />
SET @modified.modify('delete (//Properties/Cultures/Cul<wbr />ture[@cult<wbr />ureName != &quot;{ xs:string(sql:variable(&quot;@c<wbr />ulture&quot;)) }&quot;])')<br />
<br />
error:<br />
XQuery [modify()]: Syntax error near '@', expected ']'<br />

</div>
</div>


Hi All,

I have a stored procedure with a param @culture char(5)

How do I use that param in an xquery modify delete statement?

DECLARE @modified xml
.... additional code setting the @modified
SET @modified.modify('delete (//Properties/Cultures/Culture[@cultureName != "{ xs:string(sql:variable("@culture")) }"])')

error:
XQuery [modify()]: Syntax error near '@', expected ']'


paramater in xquery modify delete statement

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.