i have create a form with INSERT, DELETE, EDIT button using asp.net..
when i click INSERT button it will show "AccountNo" in DROP DOWN LIST to register new user..
i write sqL COMMAND INTO DROP DOWN LIST LIKE SELECT min(PANG) FROM (SELECT AccNo + 1 AS PANG FROM debtor EXCEPT SELECT AccNo FROM Debtor) AS boon WHERE PANG >300000000
everything was working good..
The problem is when there are two users clicking INSERT at the same time with different PC? Both will be suggested same AccountNo to register.
is TRIGGER in SQL manage this problem?
how to manage this problem with trigger?Thanks in advance
View Complete Post