• TWH (1/31/2014)


    CREATE or ALTER

    Yes! It's the one thing I miss the most from my Oracle days was being able to have a simple way to save stored procedure / view / function / etc scripts without having the awkward "if object doesn't exist, create a fake one" then ALTER it. Or worse, when someone writes a script with the DROP then CREATE methodology but doesn't include any GRANTs.

    Something else I'd change would be to get rid of SET options at the object level like:

    ANSI_NULLS

    QUOTED_IDENTIFIER

    etc.