Update and insert new rows in one query

In this week’s SQL Server e-newsletter, Arthur Fuller answers the question, “Can I update existing rows and insert (or delete) new ones in a single query?” Please let us know what you think about his answer and comments about the question.

If you aren’t subscribed to the free SQL Server e-newsletter, you can automatically subscribe to this e-newsletter by pasting the following URL into your browser:
http://nl.com.com/MiniFormHandler?brand=builder &subs_channel=bldr_front_door&list_id=e046&tag=fb

* Please delete any extra spaces that appear when you paste this URL into your browser.