I work on SQL server 2012 I face issue i can't update column serial by max + 1 where is have null value on on serial column partnumber is unique on table so i need to get max number from serial and increment it by 1 then assign it to null on serial column
meaning any partnumber is unique and have null on serial must have unique number on serial by max number on serial +1