Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 15, 2012 11:24 AM by avinash_bhudke
Member
8 Points
46 Posts
Feb 15, 2012 11:18 AM|LINK
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.
thanks
agk
Contributor
2881 Points
517 Posts
Feb 15, 2012 11:24 AM|LINK
You can refer below articles.
http://forums.asp.net/t/1762173.aspx/1
http://stackoverflow.com/questions/798192/forcing-a-query-timeout-in-sql-server
agkaiser
Member
8 Points
46 Posts
Lock SQL Table
Feb 15, 2012 11:18 AM|LINK
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.
thanks
agk
avinash_bhud...
Contributor
2881 Points
517 Posts
Re: Lock SQL Table
Feb 15, 2012 11:24 AM|LINK
You can refer below articles.
http://forums.asp.net/t/1762173.aspx/1
http://stackoverflow.com/questions/798192/forcing-a-query-timeout-in-sql-server