Posted by John Bell on 10/15/49 11:36

Hi

It is better to have some prefix than non at all in a multi-table statement,
therefore a consistent application of either method is the most important
IMO.

John

"serge" <sergea@nospam.ehmail.com> wrote in message
news:lVuvf.41896$Kf1.817743@weber.videotron.net...
> Thank you John and Erland.
>
> In our shop some people are against using aliases
> believe it or not. They would rather type the full
> table name and not use an alias.
>
> Me I am just happy I'll be able to add all the
> missing dbo. to comply with SQL Best Practices
> Analyzer and gain performance (however slight
> it may be).
>
>
>

[Back to original message]