Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: XPath query against a query plan - xmlns giving me problems

    One more way to do the same thing is declaring default element namespase "http://schemas.microsoft.com/sqlserver/2004/07/showplan" in the XQuery:

    SELECT t.c.value('@Column', 'varchar(128)') AS 'Parameter', t.c.value('@ParameterCompiledValue', 'varchar(128)') AS 'Value'

    from @x.nodes

    ('

    declare default element namespace...

Viewing post 1 (of 1 total)