[dba-SQLServer] [AccessD] Bulk insert and table names

[Arthur Fuller]

Long ago, there was a SQL equivalent of a tongue twister. I'll see if I can
recall it.

Tables:
Select
     ID autoincrement
     Select varchar(100)
From
     ID autoincrement
     From varchar(100)

Already, you can see where this is going. Parse this, you motherf**ker!

SELECT SELECT.Select, FROM.From
INNER JOIN FROM ON
SELECT.id = FROM.ID
ORDER BY SELECT.Select

Arthur the Asinine, son of Douglas the Douche (or was it the Duke?)

On Tue, Oct 2, 2007 at 11:56 AM, Francisco Tapia <fhtapia at gmail.com> wrote:

> The thing is that if you bracket your table names, you're allowed to use
> them, prefixing your table names with something simple such as tblOR or
> tblIN would have clearly avoided the problem you faced.  Similarly with
> indexes, you've found a great way to keep them unique by including the
> tablename in the index.