Answers for "update column with another column in same table sql"

SQL
0

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
0

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 with another column in same table sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language