From the SQL Programmability & API Development Team Blog, check out UPDATE with OUTPUT clause – Triggers – and SQLMoreResults