This can be achieved using Import/Export Data feature in SQL 2008.

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...