prevent Multiple users read / update table at same time

Dec 30 2018 2:53 AM

I have proplem i have table Buyer with fields BuyerId,BuyerNAme,Email Id

In my company more one user can edit in same record in same time

How to allow only one user to edit record and another user when edit same record

get message the record edit now by another user

if possible help me

what i can do to prevent this proplem

my database sql server 2017,visual studio 2017

Answers (2)