Home Forums SQL Server 7,2000 T-SQL if -- else with ALTER PROC and CREATE PROC RE: if -- else with ALTER PROC and CREATE PROC

  • January 16, 2004 at 2:10 pm

    #490544

    alter or create need to be the first thing in the batch. I typically always drop and recreate, but I keep the security with the code.

     

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com