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

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

By , 5 Jan 2011
 
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)

About the Author

Umair Feroze
Software Developer (Senior) Shams Software Services
Pakistan Pakistan
Member
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

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
Hint: For improved responsiveness ensure Javascript is enabled and choose 'Normal' from the Layout dropdown and hit 'Update'.
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page   
GeneralReason for my vote of 5 I searched alot for this error and t...memberFSUMSoft11 Jan '11 - 22:41 
GeneralReason for my vote of 5 It resolved my problem and saved my ...memberAbdul_Hafeez6 Jan '11 - 0:25 

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

Permalink | Advertise | Privacy | Mobile
Web04 | 2.6.130516.1 | Last Updated 5 Jan 2011
Article Copyright 2011 by Umair Feroze
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid