how to verify insert & delete & update are done in single stored procedure of Ms Sql server

how to verify insert & delete & update are done in single stored procedure
of Ms Sql server

I am trying to write stored procedure test case. I need to check that are
there insert and/or delete operation done with update operation. I tried
with BINARY_CHECKSUM(*) for update but how can I know that whether table
is inserted or deleted with update operation.
Thanking You.