INF: Updating Column in One Table w/ Column from Another Table

This article was previously published under Q46783
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
The following is an example of how to update a column in one tablewith a column from another table:
   UPDATE tablea   SET tablea.colb=tableb.colb   FROM tableb   WHERE tablea.cola=tablea.cola				
Transact-SQL Windows NT
Properties

Article ID: 46783 - Last Review: 02/27/2014 20:59:56 - Revision: 3.1

  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • kbnosurvey kbarchive kbprogramming KB46783
Feedback