If you drop the index on the view before running the update query, does this reduce the time taken? Does the column you are updating participate in the clustered...

Given that particular example, I think the only way to do this is with dynamic SQL using sp_executesql which accepts as parameters the SQL string to execute, a string listing...

I don't know whether it's a recommended practice or not, but sp_executesql requires a Unicode constant or variable. If a constant is specified, it has to be prefixed with...

You can create a computed column in a create or alter table statement.

E.g.

(Replace the word plus with a plus sign - its not showing when I preview