sql server - xml parsing error of the sql query -


when run query below, following error

msg 9455, level 16, state 1, line 1
xml parsing: line 31, character 19, illegal qualified name character

query:

;with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition',                      'http://schemas.microsoft.com/sqlserver/reporting/reportdesigner' rd) select     a.name,     x.value('commandtype[1]', 'nvarchar(50)') commandtype,     x.value('commandtext[1]','nvarchar(50)') commandtext      (select      name,       cast(cast(content varbinary(max)) xml) reportxml              reportserver.dbo.catalog)     cross apply       a.reportxml.nodes('/report/datasets/dataset/query') r(x)       x.value('commandtype[1]', 'nvarchar(50)') = 'storedprocedure' 


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -