Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

How do I UPDATE from a SELECT in SQL Server?

UPDATE     Table_A SET     Table_A.col1 = Table_B.col1,     Table_A.col2 = Table_B.col2 FROM     Some_Table AS Table_A     INNER JOIN Other_Table AS Table_B         ON Table_A.id = Table_B.id WHERE     Table_A.col3 = 'cool'
Source by www.thecodeteacher.com #
 
PREVIOUS NEXT
Tagged: #How #I #UPDATE #SELECT #SQL
ADD COMMENT
Topic
Name
6+7 =