THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Home

Blogs

Downloads

Opml

Merrill Aldrich

Technical content about Microsoft data technologies. All opinions expressed are purely my own and do not reflect positions of my employer or associates.

Worst possible SQL Server object name?

I currently test any dynamic sql I have to write against objects called

Patt [Y.] O'Furniture

It seems to catch the most obvious problems composing SQL on the fly, aside from name length. (Pity the person grappling with a 128 character object name!) What's the worst object name you've had to deal with?

Published Monday, October 19, 2009 2:44 PM by merrillaldrich

Filed under: naming, dynamic sql

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

	Boyan Penev said: Select [Select] From [From] Where [Where] = 'Where' And [nvarchar(50)] = 'nvarchar(50)' And [int] = 1 October 19, 2009 5:38 PM
	merrillaldrich said: Nice. Makes my brain cramp. October 19, 2009 5:54 PM
	Aaron Bertrand said: 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. October 19, 2009 5:59 PM
	Alexander Kuznetsov said: 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)); October 19, 2009 6:17 PM
	merrillaldrich said: I guess a table _containing_ SQL injection vulnerabilities could get interesting: select string from injectionStrings where string = '''; drop table users;' Think carefully before pressing F5... October 19, 2009 6:36 PM
	Paul Nielsen said: dbo.AccessImport October 19, 2009 9:09 PM
	merrillaldrich said: HA! Still, I'll take dbo.AccessImport over dbo.AccessLinkedTable any day. October 19, 2009 9:42 PM
	Antony said: I've always found the GROUP table particularly annoying. October 20, 2009 8:31 AM
	Dan said: 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. October 20, 2009 10:59 AM
	Everest said: How about this one...Celko would probably appreciate: CREATE TABLE # (iPK int IDENTITY (1,1) ,nValue nvarchar (256) ) October 20, 2009 9:46 PM
	Matt Whitfield said: Embedded square brackets CREATE TABLE [[!]]] ([]]] int IDENTITY (1,1) NOT NULL, [[[]]]]] int) SELECT [[[]]]]], []]] FROM [[!]]] October 22, 2009 10:33 AM
	a.m. said: We can take this one step further if you'd like... Don't do this at home, kids: declare @ table ([[] int) select [@].[[] from @ [@] October 22, 2009 10:39 AM
	merrillaldrich said: Holy ambiguous delimiters, Batman! How do we escape these?! Guys, these are all awesome ^ geekness. But aren't we missing whole realm of possibilities with operators? To wit: DECLARE @math TABLE ( a INT, b INT, [a + b] INT ) INSERT @math ( a, b, [a + b] ) VALUES ( 2, 2, 5 ) SELECT a, b, [a + b], ( a + b ) AS [a + b] FROM @math October 22, 2009 5:17 PM
	Armando Prato said: 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. October 23, 2009 9:51 AM
	kriki said: A database called "tlog". November 16, 2009 1:23 PM
	zzyytt said: http://www.chromehearts.net.co http://www.nike-freerun.us.com http://www.balenciagassneakers.com http://www.adidassuperstar.us.com http://www.adidas-pureboost.us.com http://www.goyard.us.com http://www.kobe-shoes.us.com http://www.converseoutlet.us.com http://www.vans-shoes.us.org http://www.nikeshoesformen.us.com http://www.nikepolo.us http://www.nikerunningshoes.us.com http://www.goyard-handbags.us.com http://www.adidasultraboost.us.org http://www.goldengoose-sneakers.com http://www.vancleefandarpels.us.com http://www.nikezoom.us.com http://www.goyardhandbags.us.com http://www.yeezy-shoes.org http://www.hermesbelts.co.uk http://www.jordanshoes.uk http://www.kyrie4.org http://www.yeezy-shoes.org.uk http://www.katespadehandbags-outlet.us.com http://www.kevindurant-shoes.us.com http://www.nikeair-max.us.com http://www.supremehoodie.us.com http://www.adidasgazelle.us.com http://www.michaelkors-outletstore.us.com http://www.nfljerseys.us.org http://www.outlettimberland.us.org http://www.louboutinshoes.uk http://www.adidas-crazyexplosive.us.com http://www.derrickroseshoes.us.com http://www.adidasstore.us.com http://www.fitflops.cc http://www.balenciagashoes.us.com http://www.johnwall-shoes.us.com http://www.adidaseqts.com http://www.yeezy-shoes.us.org http://www.adidasnmd.uk http://www.yeezysuk.com http://www.long-champhandbags.org.uk http://www.stephencurry-shoes.us.com http://www.cheaprealjordans.us.com http://www.nikerosheone.us.com http://www.yeezyshoesuk.com http://www.michaelkors-outletonlines.us.com http://www.jordan12.us.com http://www.adidasnmd-runner.us.com http://www.converse-shoes.us.com http://www.kyrie3.us.com http://www.asicsgelkayano.us.com http://www.adidasyeezys.us.com">http://www.adidasyeezys.us.com http://www.yslhandbags.org http://www.kyrie4shoes.us.com http://www.nikedunks.us.org http://www.airmax270.us.com http://www.tomford-sunglasses.us.com http://www.curry4.us.com http://www.supremeclothing.us http://www.authenticjordanscheap.us.com http://www.goldengoose.us.com http://www.fentypuma.us.com http://www.outletlacoste.us.com http://www.nike-hyperdunk.us.com http://www.adidas-tubular.us.com http://www.basketball-shoes.us.com http://www.michael--korsoutlet.us.org http://www.pandorabracelet.in.net http://www.longchamp-bags.us.org http://www.adidasstansmith.uk http://www.longchamphandbagsoutlets.com http://www.paulgeorgeshoes.us http://www.nhljerseys.us.org http://www.adidasultra.us.com http://www.adidasnmdshoes.co.uk http://www.yeezyboost.in.net http://www.lebron-soldier10.us.com http://www.lebron13.us.com http://www.cheap-airjordans.us.com http://www.oakleysunglassesonline.us.org http://www.hermes-birkin.us.com http://www.yeezy-boost350.us.com http://www.nikeoutletstoreonlineshopping.us.com http://www.nikeflyknitracer.us.com http://www.adidasiniki.us http://www.curry5.us.com">http://www.curry5.us.com http://www.adidas-zxflux.us.com http://www.atlantafalconsjerseys.us http://www.russellwestbrookshoes.us.com">http://www.russellwestbrookshoes.us.com http://www.kobesneakers.com http://www.jordan-retro.us.com http://www.nikeairmax2018.us.com http://www.ferragamobelt.us.org">http://www.ferragamobelt.us.org http://www.guccibelt.us.com http://www.cheapoakley-sunglasses.us.org http://www.vibramfivefingers.us.com http://www.monclerjacketsale.us http://www.outletonline-michaelkors.us.org http://www.offwhiteclothing.us.com http://www.balenciaga.us.com http://www.nikehuaracheshoes.us.com http://www.truereligion-outlets.us.com http://www.jordansforcheap.us.com http://www.longchamp-bag.us.com http://www.toryburchshoes.us http://www.hardenshoes.us.com http://www.adidasstansmith.us.com http://www.christian-louboutin.eu.com http://www.nikefoamposite.us.com http://www.hermesbelts.com http://www.monclerjackets.us http://www.adidasonlineshop.us.com http://www.hermes-belt.us.com http://www.hoganoutletonline.us.com http://www.nikehuarache.uk http://www.chromehearts.com.co http://www.lebron-soldier11.us.com http://www.nikecortez.us.com http://www.nike-huarache.co.uk http://www.nikesneakers.us.com http://www.yeezyboost350v2shoes.us.com http://www.redbottoms.us http://www.calvinkleinoutlet.us.com http://www.yeezyboost.com.co http://www.russellwestbrookshoes.us http://www.long-champ.us.com http://www.airjordanretro.uk http://www.bape-hoodie.us.com http://www.toryburchshoes.org.uk http://www.nike-huarache.com http://www.oakleysunglassesonlinestore.us.com http://www.adidasnmds.com http://www.adidasyeezy.co.uk http://www.ferragamobelt.us http://www.yeezysshoes.us.com http://www.bapehoodie.us http://www.chromeshearts.us.com http://www.yeezy-shoes.ca http://www.nike-airforce1.us.com http://www.monclerjacket.net http://www.kobebasketballshoes.net http://www.burberryoutlet-store.us.com http://www.michaeljordanshoes.us.com http://www.linksoflondonus.com http://www.birkinbag.us.com http://www.michaelkors-outletsonline.us.com http://www.lebron15shoes.us.com http://www.shoesjordan.us.com http://www.adidasyeezys.us http://www.curry4shoes.us.com http://www.longchamphandbagsonlines.com http://www.curry5.us http://www.linksoflondon.us.com http://www.lebron15.net http://www.michael-kors-handbags.com.co http://www.jordan6.us.com http://www.rayban-sunglassesonline.us.com http://www.kobeshoes.uk http://www.patriotsjersey.us.com http://www.vans-outlet.us.com http://www.nikeairforce1.us.com http://www.adidas-tubular.us.com http://www.kobebasketballshoes.us.com http://www.adidasoutletonline.com http://www.vapormaxshoes.us http://www.rosherun.us.com http://www.air-max.us.com http://www.fitflops-saleclearance.us.com http://www.tomfordsunglasses.us.org http://www.lebron14.us.com http://www.mlbjerseyscheap.us http://www.offwhitehoodie.us.com http://www.nikezoom.me.uk http://www.adidasyeezys.net http://www.nike-roshe.us.com http://www.raybanonlinestore.us.com http://www.hermes-handbags.us.com http://www.adidassuperstar.org.uk http://www.charmspandora.in.net http://www.michael-kors-handbags.org.uk http://www.boostyeezy.us.com http://www.yeezy700.us.com http://www.nikehyperdunk2017.us.com http://www.yeezyboost-350.com.co http://www.lacosteonlineshop.us.com http://www.airmax90.us.org http://www.reebokoutlet.us.org http://www.jordan11retro.us.com http://www.yeezyboost350v2.org.uk http://www.caterpillarboots.us.com http://www.nikemercurial.us.com http://www.paulgeorgeshoes.us.com http://www.yeezyboost-350.uk http://www.kyrieirving-shoes.us.com http://www.adidastubular.co.uk http://www.monclerjacketsoutlets.us.com http://www.retro-jordans.us.com http://www.nikerosheone.co.uk http://www.nike-airmax2017.us.com http://www.michaelkors-outletfactory.us.org http://www.goldengoose-outlet.us.com http://www.nike-airmax90.uk http://www.ultraboost.us.com http://www.damianlillardshoes.us.com http://www.nikeflyknit.us.com http://www.nikebasketballshoes.us.com http://www.michaelkorshandbag.us.org http://www.adidas-nmds.us.com http://www.jordan4.us.com http://www.truereligionjeans-outlets.us.com http://www.nike-airpresto.us.com http://www.jewelrypandora.in.net http://www.monclersoutlet.us.com http://www.asicsrunningshoes.us.org http://www.lebronjames-shoes.us.com http://www.yeezyboost-350v2.us.com http://www.yeezy-boost.us.com http://www.pradasunglasses.us.org http://www.cheapnbajerseys.us.org http://www.adidas-eqt.us.com http://www.diorsunglasses.in.net http://www.jordan13.us.com May 1, 2018 7:01 PM

Name (required)
Comments (required)
Remember Me?
Submit

Merrill Aldrich

Worst possible SQL Server object name?

Comment Notification

Comments

Boyan Penev said:

merrillaldrich said:

Aaron Bertrand said:

Alexander Kuznetsov said:

merrillaldrich said:

Paul Nielsen said:

merrillaldrich said:

Antony said:

Dan said:

Everest said:

Matt Whitfield said:

a.m. said:

merrillaldrich said:

Armando Prato said:

kriki said:

zzyytt said:

Leave a Comment

This Blog

Syndication

Recent Posts

Tags

Archives