Microsoft KB Archive/46783

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

Article ID: 46783

Article Last Modified on 12/3/2003

-

APPLIES TO


 * 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

-



This article was previously published under Q46783





SUMMARY
The following is an example of how to update a column in one table with a column from another table:

UPDATE tablea SET tablea.colb=tableb.colb FROM tableb WHERE tablea.cola=tablea.cola

Additional query words: Transact-SQL Windows NT

Keywords: kbprogramming KB46783

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.