skip to main | skip to sidebar

RockeTier Development Blog

Sunday, February 22, 2009

How to Implement a Join between 2 Tables in T-SQL/SQL Server UPDATE Statement

Thanks for WineIsGood:

UPDATE tblA
SET tblA.a_myField = tblB.b_newField
FROM tblA, tblB
WHERE tblA.a_b_id = tblB.b_id
Posted by RockeTier Develpment Team at 7:02 PM
Labels: Join, SQL Server, UPDATE

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2009 (39)
    • ►  July (6)
    • ►  June (7)
    • ►  May (3)
    • ►  April (2)
    • ►  March (7)
    • ▼  February (9)
      • Getting output paramater with ExecuteReader()
      • How to Implement a Join between 2 Tables in T-SQL/...
      • GigaSpaces XAP .NET-Java Interoperability
      • Database Connection Open/Close
      • Microsoft Visual Studio Error
      • C sharp 3 and LINQ
      • Hibernate Unique Ids
      • Hibernate: Log SQL Statements
      • SVN best practices and branching
    • ►  January (5)
  • ►  2008 (1)
    • ►  December (1)

Contributors

  • Ilan Arbiv
  • Ilya Chernyakov
  • Olga
  • RockeTier Develpment Team
  • Romi Kuntsman
  • Shachar Zehavi