How to write UPDATE SQL with Table alias in SQL Server 2014

 UPDATE B
   SET B.BANK_NAME = B.BANK_NAME + 'TEST',
       B.Bank_Remark = 'TEST'
 FROM BANK B
 WHERE B.Bank_Code = 'UOB';

Comments