|
Posted by cphite on 09/07/06 18:53
--CELKO-- wrote:
> >> I wish to create a temporary table whose name is dynamically based on the argument sic: parameter]. <<
>
> Not in an RDBMS! You missed the basic concepts of what a table is. It
> models an entity or relationship in a real world. To have tables
> created on the fly is to have a world in which elephants or any other
> entity at all can fall from the sky.
There are a lot of reasons someone might want to create a table on the
fly. They might want to store a snapshot of data at a given time that
is easily accessable. It may not fit your ideal of how SQL "should" be
used, but it's actually quite common in the real world - and it need
not invoke images of falling pachyderms.
> Next, using temp tables of any kind is a sign of poor SQL programming.
> This is just like hanging a scratch tape in a 1950's file system, so
> you can do a sequence of procedural steps instead of using declarative
> programming.
Sometimes it's just convenient to make a temp table. I'd wager most
people don't particularly care that it bothers your delicate
sensibilities.
> What is the REAL problem? Don't tell us what kind of kludge you want.
He told you what he wanted - the "problem" is your inability to
understand that most people use SQL in ways that go beyond your
precious standard.
Navigation:
[Reply to this message]
|