Worst possible SQL Server object name?

Select [Select]

From [From]

Where [Where] = 'Where'

And [nvarchar(50)] = 'nvarchar(50)'

And [int] = 1

I find that people in general are pretty good at avoiding bad characters in object names, either because they are smart about it, or because they get bitten pretty quickly if they also don't follow other good habits (like using QUOTENAME() when composing dynamic SQL.  I could com up with plenty of fictional examples, but for me, the most troublesome offenses I come across in real life are:

1. Embedded spaces or periods

2. Not descriptive enough

3. Too descriptive

Every time I have to type a tbl, vw or usp prefix, I shudder.  But these are just annoying and redundant, not necessarily problematic per se.

in DB2 the following code may work:

SELECT WHERE FROM WHERE SELECT

might be a valid query in the appropriate context:

create table where(where char(10));

dbo.AccessImport

I've always found the GROUP table particularly annoying.

We have a vendor who thinks their clever by naming & grouping their underlying schema like an OO application, "Object.Header" and "Object.Detail"  

If they actually used schemas i'd be happier, but they're all within dbo, so it's hundreds of tables following: dbo.[Object.Detail] etc.  Quite a pain.

How about this one...Celko would probably appreciate:

CREATE TABLE #

(iPK int IDENTITY (1,1)

 ,nValue nvarchar (256)

)

Embedded square brackets

CREATE TABLE [[!]]] ([]]] int IDENTITY (1,1) NOT NULL, [[[]]]]] int)

SELECT [[[]]]]], []]] FROM [[!]]]

We can take this one step further if you'd like... Don't do this at home, kids:

declare @ table ([[] int)

select [@].[[]

from @ [@]

Damn you, Adam.  That query gave me a headache. ;)

This stuff pales in comparison to column names I've had to deal with like "X" and "Y".  Yes, single character column names.

A database called "tlog".

http://feel-difference.biz

http://feel-difference.biz/#contact

http://feel-difference.biz/about.html

http://feel-difference.biz/gallery.html

http://feel-difference.biz/services.html

http://feel-very-free.biz

http://feel-very-free.biz/andheriescorts.html

http://feel-very-free.biz/bandraescorts.html

http://feel-very-free.biz/borivaliscorts.html

http://feel-very-free.biz/centralmumbaiescorts.html

http://feel-very-free.biz/chemburescorts.html

http://feel-very-free.biz/colabaescorts.html

http://feel-very-free.biz/cuffe_parade_escorts.html

http://feel-very-free.biz/dadarescorts.html

http://feel-very-free.biz/goregaonescorts.html

http://feel-very-free.biz/juhuescorts.html

http://feel-very-free.biz/lokhandwalaescorts.html

http://feel-very-free.biz/lowerparelescorts.html

http://feel-very-free.biz/mumbaiairportescorts.html

http://feel-very-free.biz/napeansearoadescorts.html

http://feel-very-free.biz/peddarroadescorts.html

http://feel-very-free.biz/powaiescorts.html

http://feel-very-free.biz/sakinakascorts.html

http://feel-very-free.biz/southmumbaiescorts.html

http://feel-very-free.biz/vileparleescorts.html

http://feel-very-free.biz/worliescorts.html

http://feel-different.in

http://feel-different.in/contact.html

http://feel-different.in/gallery.html

http://aakanxhaa.in

http://aakanxhaa.in/contact.html

http://aakanxhaa.in/gallery.html

http://aakanxhaa.in/services.html

http://aakanxhaa.in/about.html

http://wafiya.in

http://wafiya.in/about-us.html

http://wafiya.in/articles.html

http://wafiya.in/contact-us.html

http://wafiya.in//maharashtra/mumbai^Eescort.html

http://wafiya.in/westbengal/kolkata^Eescort.html

http://wafiya.in/goa/goa^Eescort.html

http://wafiya.in/maharastra/pune^Eescort.html

http://zaila.in

http://zaila.in/index.html

http://zaila.in/contact.html

http://zaila.in/escorts_in_mumbai.html

http://zaila.in/Portfolio.html

http://zaila.in/mumbai_escorts.html

http://taini.in

http://taini.in/about.html

http://taini.in/gallery.html

http://taini.in/contact.html

http://sofia.co.in

http://sofia.co.in/contact_us.html

http://sofia.co.in/rates.html

http://sofia.co.in/services.html

http://sofia.co.in/gallery.html

http://sofia.co.in/about_us.html

http://saphia.in

http://saphia.in/contact.html

http://saphia.in/services.html

http://saphia.in/gallery.html

http://saphia.in/about.html

http://pinkangelsofmumbai.in

http://pinkangelsofmumbai.in/locations.html

http://pinkangelsofmumbai.in/price.html

http://pinkangelsofmumbai.in/services.html

http://pinkangelsofmumbai.in/girls.html

http://pinkangelsofmumbai.in/about.html

http://pinkflowers.in

http://pinkflowers.in/contact.html

http://pinkflowers.in/gallery.html

http://pinkflowers.in/services.html

http://pinkflowers.in/about.html

http://payalmehra.in

http://payalmehra.in/Contact.html

http://payalmehra.in/Pricing.html

http://payalmehra.in/erotic.html

http://payalmehra.in/gallery.html

http://pancy.in

http://pancy.in/contact.html

http://pancy.in/about.html

http://pancy.in/gallery.html

http://pallavidutta.in

http://pallavidutta.in/index.html

http://pallavidutta.in/contact.html

http://pallavidutta.in/links.html

http://pallavidutta.in/gallery.html

http://pallavidutta.in/about.html

http://paari.in

http://paari.in/index.html

http://paari.in/about.html

http://paari.in/gallery.html

http://paari.in/rates.html

http://paari.in/contact.html

http://neetu.in

http://neetu.in/index.html

http://neetu.in/gallery.html

http://neetu.in/about.html

http://neetu.in/services.html

http://neetu.in/contacts.html

http://neetu.in/andheri_escorts.html

http://neetu.in/bandra_escorts.html

http://neetu.in/colaba_escorts.html

http://neetu.in/juhu_escorts.html

http://neetu.in/navi_mumbai_escorts.html

http://neetu.in/powai_escorts.html

http://neetu.in/vashi_escorts.html

http://neetu.in/vile_parle_escorts.html

http://khusbu.in

http://girlfriendexperience.biz

http://girlfriendexperience.biz/contact.html

http://girlfriendexperience.biz/portfolio.html

http://girlfriendexperience.biz/about.html

http://edie.in

http://edie.in/contacts.html

http://edie.in/outcall.html

http://edie.in/incall.html

http://edie.in/vip_call_girls.html

http://edie.in/female_escorts.html

http://edie.in/independent_girl.html

http://edie.in/housewife.html

http://edie.in/airhostess.html

http://edie.in/college_girls.html

http://edie.in/model_escorts.html

http://edie.in/about.html

http://edie.in/index.html

http://dassy.in

http://dassy.in/contact.html

http://dassy.in/downloads.html

http://dassy.in/services.html

http://dassy.in/projects.html

http://dally.in

http://dally.in/contacts.html

http://dally.in/gallery.html

http://dally.in/rates.html

http://dally.in/service.html

http://dally.in/about.html

http://cadee.in

http://cadee.in/contact.html

http://cadee.in/gallery.html

http://cadee.in/rates.html

http://cadee.in/services.html

http://cadee.in/about.html

http://ansu.co.in

http://ansu.co.in/contact.html

http://ansu.co.in/gallery.html

http://ansu.co.in/prices.html

http://ansu.co.in/services.html

http://ansu.co.in/gfe-escorts.html

http://antra.co.in

http://anila.in

http://anila.in/about.html

http://anila.in/gallery.html

http://anila.in/services.html

http://anila.in/rates.html

http://anila.in/contact.html

http://juhuescorts.in

http://juhuescorts.in/girls.html

http://juhuescorts.in/services.html

http://juhuescorts.in/areas-covered.html

http://juhuescorts.in/bookings.html

http://juhuescorts.in/prices.html

http://juhuescorts.in/contact.html

http://thaneescorts.in

http://thaneescorts.in/gallery.html

http://thaneescorts.in/contact.html

http://zanu.in

http://zanu.in/about.html

http://zanu.in/gallery.html

http://zanu.in/contact.html

http://www.a-way-2-silk.in/ahmedabad_escorts.html

http://www.a-way-2-silk.in/airoli_escorts.html

http://www.a-way-2-silk.in/andheri_escorts.html

http://www.a-way-2-silk.in/anjuna-beach-escorts.html

http://www.a-way-2-silk.in/arpora-escorts.html

http://www.a-way-2-silk.in/baga-beach-escorts.html

http://www.a-way-2-silk.in/bandra_escorts.html

http://www.a-way-2-silk.in/baner-escorts.html

http://www.a-way-2-silk.in/belapur_escorts.html

http://www.a-way-2-silk.in/bicholim-escorts.html

http://www.a-way-2-silk.in/borivali_escorts.html

http://www.a-way-2-silk.in/bund-garden-escorts.html

http://www.a-way-2-silk.in/calangute-beach.html

http://www.a-way-2-silk.in/candolim-beach-escorts.html

http://www.a-way-2-silk.in/central-mumbai-escorts.html

http://www.a-way-2-silk.in/chembur-escorts.html

http://www.a-way-2-silk.in/chinchwad-escorts.html

http://www.a-way-2-silk.in/colaba_escorts.html

http://www.a-way-2-silk.in/cuffe-parade-escorts.html

http://www.a-way-2-silk.in/dadar-escorts.html

http://www.a-way-2-silk.in/ghansoli_escorts.html

http://www.a-way-2-silk.in/ghodbunder_road_escorts.html

http://www.a-way-2-silk.in/goa_escorts.html

http://www.a-way-2-silk.in/goa-beach-escorts.html

http://www.a-way-2-silk.in/goregaon-escorts.html

http://www.a-way-2-silk.in/hinjewadi-escorts.html

http://www.a-way-2-silk.in/jadavpur-escorts.html

http://www.a-way-2-silk.in/juhu_escorts.html

http://www.a-way-2-silk.in/kalamboli_escorts.html

http://www.a-way-2-silk.in/kalyani-nagar-escorts.html

http://www.a-way-2-silk.in/kamothe_escorts.html

http://www.a-way-2-silk.in/kapurbadi_escorts.html

http://www.a-way-2-silk.in/khandala-escorts.html

http://www.a-way-2-silk.in/khar_escorts.html

http://www.a-way-2-silk.in/kharadi-escorts.html

http://www.a-way-2-silk.in/kharghar_escorts.html

http://www.a-way-2-silk.in/kolkata-escorts.html

http://www.a-way-2-silk.in/kopar_khairane_escorts.html

http://www.a-way-2-silk.in/koregaon-park-escorts.html

http://www.a-way-2-silk.in/korum_mall_escorts.html

http://www.a-way-2-silk.in/lokhandwala-escorts.html

http://www.a-way-2-silk.in/lonavala-escorts.html

http://www.a-way-2-silk.in/lower-parel-escorts.html

http://www.a-way-2-silk.in/mapusa-escorts.html

http://www.a-way-2-silk.in/margo-beach-escorts.html

http://www.a-way-2-silk.in/mg-road-escorts.html

http://www.a-way-2-silk.in/mumbai_airport_escorts.html

http://www.a-way-2-silk.in/mumbai_escorts.html

http://www.a-way-2-silk.in/napean-sea-road-escorts.html

http://www.a-way-2-silk.in/navi_mumbai_escorts.html

http://www.a-way-2-silk.in/nerul_escorts.html

http://www.a-way-2-silk.in/nerul-beach-escorts.html

http://www.a-way-2-silk.in/north-goa-escorts.html

http://www.a-way-2-silk.in/panaji-escorts.html

http://www.a-way-2-silk.in/panvel-escorts.html

http://www.a-way-2-silk.in/park-circus-escorts.html

http://www.a-way-2-silk.in/park-street-escorts.html

http://www.a-way-2-silk.in/patuli-garia-escorts.html

http://www.a-way-2-silk.in/peddar-road-escorts.html

http://www.a-way-2-silk.in/pernem-escorts.html

http://www.a-way-2-silk.in/powai_escorts.html

http://www.a-way-2-silk.in/pune_escorts.html

http://www.a-way-2-silk.in/rajarhat-escorts.html

http://www.a-way-2-silk.in/saki_naka_escorts.html

http://www.a-way-2-silk.in/sanpada_escorts.html

http://www.a-way-2-silk.in/sb-road-escorts.html

http://www.a-way-2-silk.in/shivaji-nagar-escorts.html

http://www.a-way-2-silk.in/siolim-escorts.html

http://www.a-way-2-silk.in/sonarpur-escorts.html

http://www.a-way-2-silk.in/south-goa-escorts.html

http://www.a-way-2-silk.in/south-mumbai-escorts.html

http://www.a-way-2-silk.in/taluja_escorts.html

http://www.a-way-2-silk.in/thane_east_escorts.html

http://www.a-way-2-silk.in/thane_escorts.html

http://www.a-way-2-silk.in/thane_west_escorts.html

http://www.a-way-2-silk.in/turbhe_escorts.html

http://www.a-way-2-silk.in/ulwe_escorts.html

http://www.a-way-2-silk.in/vagator-escorts.html

http://www.a-way-2-silk.in/varca-beach-escorts.html

http://www.a-way-2-silk.in/vashi_escorts.html

http://www.a-way-2-silk.in/vile_parle_escorts.html

http://www.a-way-2-silk.in/viman-nagar-escorts.html

http://www.a-way-2-silk.in/worli_escorts.html