DELETE … OUTPUT COUNT(DELETED.*)

sql,sql-server,output-clause

Just run your query and get the modified rows DELETE FROM datacache WHERE [email protected] SELECT @@ROWCOUNT ...