This blog shows how to use a large data to update in the database using the Update statement. We have scenarios where we use some large texts to be stored in a table and we need to update that.
Syntax:
Update Table
Set Columnname = 'Content'
Where Condition
In our example we have a table with column as datatype varchar(max)
Example:
Update Emptable
Set empresume = ' Put the whole content here of the resume '
Where empid = 1