Click here to Skip to main content
15,880,905 members
Articles / Database Development / SQL Server
Alternative
Tip/Trick

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

Rate me:
Please Sign up or sign in to vote.
4.89/5 (2 votes)
5 Jan 2011CPOL 14.4K   2   2
You can also enclose your column name in brackets, like so: [Create Date]
You can also enclose your column name in brackets, like so: [Create Date]

License

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


Written By
Software Developer (Senior) Paddedwall Software
United States United States
I've been paid as a programmer since 1982 with experience in Pascal, and C++ (both self-taught), and began writing Windows programs in 1991 using Visual C++ and MFC. In the 2nd half of 2007, I started writing C# Windows Forms and ASP.Net applications, and have since done WPF, Silverlight, WCF, web services, and Windows services.

My weakest point is that my moments of clarity are too brief to hold a meaningful conversation that requires more than 30 seconds to complete. Thankfully, grunts of agreement are all that is required to conduct most discussions without committing to any particular belief system.

Comments and Discussions

 
QuestionRAW and AUTO are cool ... Pin
RedDk27-Jun-16 8:09
RedDk27-Jun-16 8:09 
GeneralI used the query in the below way but error was still there:... Pin
Umair Feroze5-Jan-11 6:22
Umair Feroze5-Jan-11 6:22 

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

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