Sergiy (5/24/2013)
GilaMonster (5/24/2013)
I never claimed or stated anywhere that it has any effect on the insertLook, 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.
I never claimed it had an effect, on the whole or the part, in that statement or any other. I stated it is valid, that is, it parses successfully.
So, at least one of your statements is wrong.
Except I never made such a statement. If you want to claim I said something I never did, please, by all means carry on, have fun.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability