[SQL] Indirectly working with tables

How is this done? I've seen people say this but

update tablename/view
set x = @x
where p = @p

both of these seem rather direct to me. Is there some other way I'm missing. Also if you have access to Dynamic SQL and Stored Procedures why would you ever use inline SQL?

Databases considered harmful.

harm considered harmful