Click here to Skip to main content
Click here to Skip to main content

Tagged as

Go to top

"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."

, 5 Jan 2011
Rate this:
Please Sign up or sign in to vote.
To resolve the invalid chracter from FOR XML PATH clause
Background
 
I have a stored procedure which returns data as an XML node. This stored procedure uses temp table to populate data. The column names in the temp table contain spaces, i.e. [Create Date].
 
Error
"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."
 
Resolution
 
After removing spaces from the column names, this error was resolved.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Umair Feroze
Software Developer (Senior) Shams Software Services
Pakistan Pakistan
I have been working as a Senior Software Analyst in Shams Software Services and during this I have been working in Sql Server and C# .Net

Comments and Discussions

 
GeneralReason for my vote of 5 I searched alot for this error and t... PinmemberFSUMSoft11-Jan-11 22:41 
GeneralReason for my vote of 5 It resolved my problem and saved my ... PinmemberAbdul_Hafeez6-Jan-11 0:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140921.1 | Last Updated 5 Jan 2011
Article Copyright 2011 by Umair Feroze
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid