SQL Server Transact Basic to Expert - Update Query With Large Data concantinated

This blog show how to update the column or we can say to concantinate some data to the exisitng column using the Update statement. Update statement has a property .Write which provides this feature to do a concantination to the existing available data in a column.

Syntax:

Update Table
Set Column = .write(Value, @offset, @length)
Where Condition

Example:

Update Emptable
Set empresume = ' Put the whole content here of the resume '
Where empid = 1

Update table
Set empresume = .Write('Adding some extra comments here', null, null)
Where empid = 1

So in the result set we will have the combined value in the empresume column as "Put the whole content here of the resume Adding some extra comments here"