Home Forums SQL Server 2005 SQL Server 2005 General Discussion Update one column of a table with data from another table RE: Update one column of a table with data from another table

  • March 20, 2013 at 8:00 am

    #1598913

    Hi,

    Try this one

    UPDATE bck

    SET bck.ProcID = ori.ProcID

    FROM dbo.BlogCopy_copy as bck inner join dbo.BlogProcedures as ori

    on bck.WebID=ori.WebID

    Using aliasses of tables is a good habit that you really should learn to use 🙂

    Wkr,

    Van Heghe Eddy