T-SQLpowered

UPDATE

Update with the expression:

UPDATE [dbo].[SampleTable] SET [Col1] = @a + @b + @c

Update using the .WRITE() clause:

UPDATE [dbo].[SampleTable] SET [Col1].WRITE('New Value, 0, NULL)
UPDATE [dbo].[SampleTable] SET [Col1].WRITE(@a + @b + @c, 0, NULL)
UPDATE [dbo].[SampleTable] SET [Col1].WRITE(@x, 500, 1000)