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)

Vishal Jadav · Answer

Hi Whats the issue you are facing in it ? Because you need to do it this way only by passing insertby or updateby id from the code it self. I think this is the right way of doing it. Thanks.

Atul Patil · Answer

ALTER PROCEDURE [dbo].[insert_user] @firstname varchar(50) @lastname varchar(50) @email varchar(100) @contact varchar(15) @address1 varchar(500) @address2 varchar(500) @city varchar(50) @country varchar(50) @created_by int @user_type int @user_role int AS Begin begin try begin transaction insertTrans IF (SELECT COUNT(*) FROM [dbo].[user] WHERE first_name = @firstname AND last_name=@lastname and email=@email and contact=@contact) = 0 begin insert into [dbo].[user] ( [first_name] [last_name] [email] [contact] [address1] [address2] [city] [country] [created_at] [created_by] [updated_at] [updated_by] [user_type] [user_role] [is_active] ) values ( @firstname  @lastname  @email  @contact  @address1  @address2  @city  @country  getdate()  @created_by  getdate() @created_by @user_type @user_role '1' ) end commit transaction insertTrans end try begin catch throw rollback transaction insertTrans end catch END

Manas Mohapatra · Answer

What is the issue you are facing now..please share details..

Vishal Jadav · Answer

Hi If possible you can pass the operatorid in UpdatedBy / CreatedBy for further use. If possible can you provide the stored procedure ? Thank you Jadav Vishal

Ehsan Sajjad · Answer

can you show your stored procedure how you have wrote it ?