在单一更新语句中实现该目标的一种方法:

One way to achieve that in a sinlge update statement:

q) update FirstName:?[SecondName like ""; SecondName;FirstName], FullName:s-s-r[;" "; " "]@'FullName from table