GilaMonster (5/24/2013)
I never claimed or stated anywhere that it has any effect on the insert
Look, just 1 row above you say:
the select portion of an insert statement
If anything has an effect on the part than it mast have an effect of the whole.
If SELECT is a potion of INSERT, as you say, then aliasing which changes SELECT must make a difference on INSERT.
Which - again, as you say - it does not.
So, at least one of your statements is wrong.
I say - it's the one where you unite SELECT and INSERT into one statement.
They are not.
SELECT is not a portion of INSERT.
INSERT may use any source of recordsets, not only SELECT queries.
It may be EXEC one as well.
Or an array of "VALUES".
All examples of smart (or not, does not matter) aliasing belong to SELECT statement and have nothing to do with INSERT.
Only "aliasing" which is relevant to INSERT happens in between the brackets following the name of the table.
_____________
Code for TallyGenerator