Home Forums SQL Server 2008 T-SQL (SS2K8) Performing a ALTER TABLE then modifying data in same transaction scope? RE: Performing a ALTER TABLE then modifying data in same transaction scope?

  • September 12, 2012 at 7:41 am

    #1536711

    Without a GO, the entire thing (alter and subsequent data modifications) gets parsed as a batch and the parsing happens before anything is run. Hence if the alter adds a column, the data modifications can't affect that column in the same batch, because at parse (and optimisation) time, the new column isn't there.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass