I have proplem i have table employee with fields EmployeeID,EmployeeName,Telephone
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
ahmed saPosted Feb 25, 2015, 7:49 AM
ahmed saPosted Feb 25, 2015, 7:03 AM
Khargesh RajputPosted Feb 25, 2015, 2:59 AM
ahmed saPosted Feb 25, 2015, 2:28 AM
suppose i need to make update the employee as following
CREATE PROC UPDATE_EMPLOYEE
(
@EmployeeID INT,
@EmployeeName NVARCHAR(50)
)
AS
update Employee set EmployeeName=@EmployeeName where EmployeeID=@EmployeeID
Suppose I have two useres A,B
A modified or edit using stored procedure above employee no 5000 field EmployeeName
B need to modify employee no 5000 using stored procedure above field EmployeeName
i need to prevent user B To modify same record using time stamp How to do that from c# code and sql server and what modification in stored procedure to accept timestamp
EmployeeTable
EmployeeID
EmployeeName
TimeStampEmp
Khargesh RajputPosted Feb 24, 2015, 11:27 PM
another is you can add updatedby column and insert the userid of user who update the record