Partial-update transaction directly writes a character string at a user-defined position of a table column without issuing a delete and replace command, as would happen in a full update.
Partial update does not support multibyte character set conversion. Partial update support is restricted to Microsoft SQL Server .