Update vs Select Then Update
679656Feb 4 2009 — edited Feb 5 2009Is there any additional overhead with an update statement that doesn't update rows vs a select statement?
I'm trying to find out if its better to query with a select then update based on the results. Or should I just do an update statement with a where clause. The reason is because most of the time my update statement doesn't update any values.