UPDATE receiveRecordItem SET goodsName = (SELECT CASE WHEN specification='' THEN name WHEN specification is null THEN name ELSE name + '['+specification+']' END FROM DiposableGoods where id= diposableGoodsID) WHERE goodsName is null and diposableGoodsID is not null;