How to lock a record in sqlserver 2005
I want to lock the record in sqlserver, so other users cannot change it.
I have a table in SQL with name tbl_SerialNoGenerator
in this i have columnname(SerialNo) which has serialnos from 1001 to 50000
In asp.net webpage i have form with label, textboxes and btn which generates this serialNo. using label.
On every pageload it generates serialno. from database and puts on label.
So no. of users uses different forms.
Till here its working fine.
So I need help here, I want to Lock to record. so other users will not generate same serialno.
Please help me, how to lock the record in SQL.