Looking for my RSS feed? Here it is!

Strange SQL Server Column Names

Wednesday, February 14, 2007

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!

posted by David Betz at 2/14/2007 2:38 PM

{LLBLGen Pro}

Math Problem: 5 + 7 (type the answer in the box)

Notice: all comments are subject to moderation.

Comment saved. All comments are moderated and may not show up for some time.

Creative Commons License
This work is licensed under a Creative Commons Attribution 2.5 License.

Powered by the Minima Blog Engine, NetFXHarmonics Prominax, and Squid Micro-Blogging library.

Developed using NetFXHarmonics DevServer.

Mini-icons are part of the Silk Icons set of icons at famfamfam.com