sql,sql-server,output-clause
Just run your query and get the modified rows DELETE FROM datacache WHERE [email protected] SELECT @@ROWCOUNT ...