Lock SQL Table RRS feed

  • Question

  • User778194810 posted

    Dear Friends ,

    iam new to sql, iam using ASP.NET and sql server   

    I have stock table , from this table one user  fetch some rows from by sql query and display in grid for billing.

    in this mean time another user cannot fetch these records for billing , it should be locked until the first user made a bill.

    how to lock table please suggest me.





    Wednesday, February 15, 2012 7:18 AM