Print data in MSSQL after transact

If you want to give information after the transact, let's assume an update

table’s picture

UPDATE Production_Units Set deleted=0 WHERE Id = 3

I did this with the stored procedure because I want to give permission to my users. On the backend(i used c#), I want to review completed with success or not

So there are two way

1. “INSERTED” contains the new rows (INSERT or UPDATE‘s SET)
2. “DELETED” contains the old copy of the rows(UPDATE‘s SET)

here the returnId