Answers for "update column based on another column which is present another table sql"

sql server update column based on another table

UPDATE
    Sales_Import
SET
    Sales_Import.AccountNumber = RAN.AccountNumber
FROM
    Sales_Import SI
INNER JOIN
    RetrieveAccountNumber RAN
ON 
    SI.LeadID = RAN.LeadID;

Posted by: Guest on April-01-2021

update one column from another column in same table

select * from stuff

update stuff
set TYPE1 = TYPE2
where TYPE1 is null;

update stuff
set TYPE1 = TYPE2
where TYPE1 ='Blank';

select * from stuff

Posted by: Guest on August-29-2021

Code answers related to "update column based on another column which is present another table sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "update column based on another column which is present another table sql"

Code answers related to "update column based on another column which is present another table sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "update column based on another column which is present another table sql"

Code answers related to "update column based on another column which is present another table sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us