Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jacob Sebastian XML Workshop 24 - Modifying XML Documents Using XQuery Part 1 RE: XML Workshop 24 - Modifying XML Documents Using XQuery Part 1

  • July 22, 2009 at 10:05 am

    #1028472

    mg (7/22/2009)

    In example 10 where you delete the “city” attribute where the “team” is “SQL Server” is there any way to pass in the “SQL Server” as a variable instead of using a constant?

    Thanks,

    Marlin

    Marlin,

    You can use a variable as given in the following example

    DECLARE @x XML

    SELECT @x = '

    '

    DECLARE @Team VARCHAR(20)

    SELECT @Team = 'SQL Server'

    SET @x.modify('

    delete (Employees/Employee[@Team=sql:variable("@Team")]/@city)

    ')

    SELECT @x

    /*

    */

    .