select update(1)

• mssql select update

  UPDATE ta SET ta.col=tb.col FROM tableNameA ta LEFT JOIN tableNameB tb ON ta.key=tb.key

  2012.01.31