this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...
I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...