Nice post.

Here's a script to just update data in a particular column in a table

select

'update @tablename set @columnname = ',

'''' + @columnname + '''',

'where @primarykeycolumn = ',

@primarykeycolumn

from @tablename

It generates a script which when run, updates that particular column in that table.