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 VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES
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
SQL 2016 DESIGN & PROGRAMMING
 
 
 
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