Strange SQL Server Column Names
OK, this is strange stuff... Today I was working with Frans Bouma on an LLBLGen problem I was having and we both came to an interesting realization that surprised us both. This sample table should explain it...
create table Cursing ( [@)^!@*&%';] int primary key identity(1, 1) not null, [%!@#$%%%] varchar(20), [\234@#$+_!@#$=] bit, [@#%*@#$%#$%%] datetime, )
That actually works!
We actually found a column with an odd name similar to the above in a table in a database at the company I work at. The table literally had a column named "%". Seriously. I'm only partly surprised as the table in question was created my Microsoft Navision 3.x. That thing has some REALLY weird table names... and now I see it has even weirder column names.
Why in the WORLD can we have weird characters as field names? Who in the WORLD requested that feature? Why? That's partly rhetorical, but it seriously makes me wonder!