Something I didn’t know existed was the OUTPUT command in SQL Server: Instead of just being told how many rows your SQL affected in a DELETE or UPDATE statement you can actually see what rows were affected. e.g. DELETE FROM
Something I didn’t know existed was the OUTPUT command in SQL Server: Instead of just being told how many rows your SQL affected in a DELETE or UPDATE statement you can actually see what rows were affected. e.g. DELETE FROM