How perform created_by and updated_by in store procedure?

Question

How perform following operation in Insert and Update store procedure?

 

I want to implement an abstract entity from which I will derive my entities. This abstract entity will contain the common fields like:

Key (int)
CreatedBy (String)
UpdatedBy (String)
CreatedDate (DateTime)
UpdatedDate (DateTime)