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

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