Post reply

T SQL joins to ansi sql joins conversion

  • March 22, 2012 at 1:33 pm

    #1462986

    A real hyperlink:

    http://connect.microsoft.com/SQLServer/feedback/details/715944/query-designer-wrongly-converts-the-non-ansi-joins

  • March 22, 2012 at 1:44 pm

    #1462993

    That's precisely the point! It is imperative that parallel testing be done. The SSMS Query Designer is a shortcut to gain a starting point without rewriting all syntax by hand. We can see that it does not consider query plans or actual resultsets when rewriting queries.

    Also consider that when using this method, many times it is when migrating from another platform, and as Joe pointed out, ambiguities in previous SQL standards plus semantic differences vendor implementations will inevitably create inconsistencies across platforms, meaning many times two vendor's will interpret the same query and produce different resultsets for the same inputs. To my knowledge nothing exists, save for parallel testing, that will be able to reconcile that.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply