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 ?

How perform created_by and updated_by in store procedure?

Answers (5)