Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: ansi sql

Cross-UPDATEs

A cross-UPDATE is an UPDATE operation that includes one or more other tables, using a JOIN. This is very useful in order to update one table with a value derived from another table.

Continue reading Cross-UPDATEs
Published 2014-02-23
Categorized as Basics, T-SQL Tagged ansi sql, cross table update, cross update, deterministic, duplicate, join, merge, msg 8672
sqlsunday.com
Proudly powered by WordPress.