Microsoft - Microsoft SQL Server - SQL - Columns - Update Columns

UPDATE dbo.dcsINGRES_Cust_Type_7_Splitting_FullConstruct_W01_UK SET Cus_type_No_Display = Custype_No, 
Cus_type_Desc_Display = Custype_Desc

NOTE: Target Column must be first.