DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS   SQL 2014 PROGRAMMING   DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
How to perform update from two tables?

The following Microsoft SQL Server T-SQL scripts demonstrate how to perform a table UPDATE from another table:.

-- SQL Server UPDATE table with values from another table - QUICK SYNTAX

-- T-SQL multiple tables update - SQL Server inner join update

UPDATE sod

  SET sod.ModifiedDate = soh.ModifiedDate

FROM AdventureWorks2008.Sales.SalesOrderHeader soh

  INNER JOIN AdventureWorks2008.Sales.SalesOrderDetail sod

    ON soh.SalesOrderID = sod.SalesOrderID

-- (121317 row(s) affected)

------------

-- SQL Server update from another table - sql server insert another table
-- Create table with SELECT INTO for testing
- Price is increased with $1.00
USE tempdb;

SELECT ProductID, ProductName = Name, ListPrice = ListPrice + 1.00

INTO Product

FROM AdventureWorks2008.Production.Product

GO

-- (504 row(s) affected)

SELECT ZeroPrice=COUNT(*) FROM Product WHERE ListPrice = 0

-- 0

 

-- SQL update from another table - two tables update sql server

-- Restore original price only when it is 1.0 - Leave other prices increased

UPDATE p

SET p.ListPrice = aw8.ListPrice

FROM Product p

INNER JOIN AdventureWorks2008.Production.Product aw8

ON p.ProductID = aw8.ProductID

WHERE p.ListPrice = 1.00

GO

-- (200 row(s) affected)

 

SELECT ZeroPrice=COUNT(*) FROM Product WHERE ListPrice = 0

GO

-- 200

DROP TABLE tempdb.dbo.Product

 

Related articles:

 

http://sqlusa.com/articles2005/updatesyntax/

 

SQL update from one Table to another based on a ID match

 

 

 

Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE