|
|
You're in the
sql server programming
group:selecting and locking a record from distributed DB
sql server programming:
hi
everyone I have a problem that I have an application having a shared DB and I want that when I retrieve a record from database for one machine then that record must be locked so that others couldnot modify that record. I need urgant help I shall be thankful to all of you if anybody can help me.
Actually I want that If my system gives one record to one person for
modification or to do some work on it then record must not be given to any other. for example in this case I have a project for telemarkting. there are 3-4 person sitting in front of systems and have one shared DB. Now my project should gave them a Company's contact no so that they can communicate with that company. I want that if my syatem gives company record 1 to employee 1 then it should not be given to any other person. Can you guide me about stored procedure that can do this or is there any alternative way availabe for it. Ishall be very thankful to you. [quoted text, click to view] Uri Dimant wrote:
> I'm not sure that understand your requirement > > BEGIN TRAN > > SELECT col FROM TableName (UPDLOCK,HOLDLOCK) > > > COMMIT TRAN > > Note, readers don't get blocked > > "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message > news:1159158795.894329.64950@m7g2000cwm.googlegroups.com... > > hi > > everyone I have a problem that I have an application having a shared DB > > and I want that when I retrieve a record from database for one machine > > then that record must be locked so that others couldnot modify that > > record. I need urgant help I shall be thankful to all of you if anybody > > can help me. > >
Hi [quoted text, click to view] > can communicate with that company. I want that if my syatem gives > company record 1 to employee 1 then it should not be given to any other > person. Can you guide me about stored procedure that can do this or is > there any alternative way availabe for it. Ishall be very thankful to > you. And others are just waiting or what? Again BEGIN TRAN COMMIT TRAN will lock the session untill it the transaction will be commited or rollback Another way I can think is to maintain an additon column to indicate whether the company ID has aleady given and doing an appropriate job for others [quoted text, click to view] "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message news:1159162220.441699.239370@d34g2000cwd.googlegroups.com... > Actually I want that If my system gives one record to one person for > modification or to do some work on it then record must not be given to > any other. for example in this case I have a project for telemarkting. > there are 3-4 person sitting in front of systems and have one shared > DB. Now my project should gave them a Company's contact no so that they > can communicate with that company. I want that if my syatem gives > company record 1 to employee 1 then it should not be given to any other > person. Can you guide me about stored procedure that can do this or is > there any alternative way availabe for it. Ishall be very thankful to > you. > > Uri Dimant wrote: >> I'm not sure that understand your requirement >> >> BEGIN TRAN >> >> SELECT col FROM TableName (UPDLOCK,HOLDLOCK) >> >> >> COMMIT TRAN >> >> Note, readers don't get blocked >> >> "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message >> news:1159158795.894329.64950@m7g2000cwm.googlegroups.com... >> > hi >> > everyone I have a problem that I have an application having a shared DB >> > and I want that when I retrieve a record from database for one machine >> > then that record must be locked so that others couldnot modify that >> > record. I need urgant help I shall be thankful to all of you if anybody >> > can help me. >> > >
I'm not sure that understand your requirement
BEGIN TRAN SELECT col FROM TableName (UPDLOCK,HOLDLOCK) COMMIT TRAN Note, readers don't get blocked [quoted text, click to view] "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message news:1159158795.894329.64950@m7g2000cwm.googlegroups.com... > hi > everyone I have a problem that I have an application having a shared DB > and I want that when I retrieve a record from database for one machine > then that record must be locked so that others couldnot modify that > record. I need urgant help I shall be thankful to all of you if anybody > can help me. >
Hi
CREATE PROCEDURE usp_GetCompanyCode @CompanyCode INT AS BEGIN TRAN SELECT <columns> FROM TableName WITH (UPDLOCK,HOLDLOCK) --Do here another operation COMMIT TRAN GO ---Usage EXEC usp_GetCompanyCode @CompanyCode =1000 [quoted text, click to view] "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message news:1159170935.933457.159040@m7g2000cwm.googlegroups.com... > Others are also getting data from the DB at the same time. Also kindly > if you can give me stored procedure code do give me I need it very > badly. > Uri Dimant wrote: >> Hi >> >> > can communicate with that company. I want that if my syatem gives >> > company record 1 to employee 1 then it should not be given to any other >> > person. Can you guide me about stored procedure that can do this or is >> > there any alternative way availabe for it. Ishall be very thankful to >> > you. >> >> And others are just waiting or what? >> >> Again >> BEGIN TRAN >> COMMIT TRAN >> will lock the session untill it the transaction will be commited or >> rollback >> >> Another way I can think is to maintain an additon column to indicate >> whether >> the company ID has aleady given and doing an appropriate job for others >> >> >> >> >> "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message >> news:1159162220.441699.239370@d34g2000cwd.googlegroups.com... >> > Actually I want that If my system gives one record to one person for >> > modification or to do some work on it then record must not be given to >> > any other. for example in this case I have a project for telemarkting. >> > there are 3-4 person sitting in front of systems and have one shared >> > DB. Now my project should gave them a Company's contact no so that they >> > can communicate with that company. I want that if my syatem gives >> > company record 1 to employee 1 then it should not be given to any other >> > person. Can you guide me about stored procedure that can do this or is >> > there any alternative way availabe for it. Ishall be very thankful to >> > you. >> > >> > Uri Dimant wrote: >> >> I'm not sure that understand your requirement >> >> >> >> BEGIN TRAN >> >> >> >> SELECT col FROM TableName (UPDLOCK,HOLDLOCK) >> >> >> >> >> >> COMMIT TRAN >> >> >> >> Note, readers don't get blocked >> >> >> >> "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message >> >> news:1159158795.894329.64950@m7g2000cwm.googlegroups.com... >> >> > hi >> >> > everyone I have a problem that I have an application having a shared >> >> > DB >> >> > and I want that when I retrieve a record from database for one >> >> > machine >> >> > then that record must be locked so that others couldnot modify that >> >> > record. I need urgant help I shall be thankful to all of you if >> >> > anybody >> >> > can help me. >> >> > >> > >
Others are also getting data from the DB at the same time. Also kindly
if you can give me stored procedure code do give me I need it very badly. [quoted text, click to view] Uri Dimant wrote:
> Hi > > > can communicate with that company. I want that if my syatem gives > > company record 1 to employee 1 then it should not be given to any other > > person. Can you guide me about stored procedure that can do this or is > > there any alternative way availabe for it. Ishall be very thankful to > > you. > > And others are just waiting or what? > > Again > BEGIN TRAN > COMMIT TRAN > will lock the session untill it the transaction will be commited or > rollback > > Another way I can think is to maintain an additon column to indicate whether > the company ID has aleady given and doing an appropriate job for others > > > > > "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message > news:1159162220.441699.239370@d34g2000cwd.googlegroups.com... > > Actually I want that If my system gives one record to one person for > > modification or to do some work on it then record must not be given to > > any other. for example in this case I have a project for telemarkting. > > there are 3-4 person sitting in front of systems and have one shared > > DB. Now my project should gave them a Company's contact no so that they > > can communicate with that company. I want that if my syatem gives > > company record 1 to employee 1 then it should not be given to any other > > person. Can you guide me about stored procedure that can do this or is > > there any alternative way availabe for it. Ishall be very thankful to > > you. > > > > Uri Dimant wrote: > >> I'm not sure that understand your requirement > >> > >> BEGIN TRAN > >> > >> SELECT col FROM TableName (UPDLOCK,HOLDLOCK) > >> > >> > >> COMMIT TRAN > >> > >> Note, readers don't get blocked > >> > >> "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message > >> news:1159158795.894329.64950@m7g2000cwm.googlegroups.com... > >> > hi > >> > everyone I have a problem that I have an application having a shared DB > >> > and I want that when I retrieve a record from database for one machine > >> > then that record must be locked so that others couldnot modify that > >> > record. I need urgant help I shall be thankful to all of you if anybody > >> > can help me. > >> > > >
Thank You very much Uri for your so much Cooperation. I have tried it
and got desired result. [quoted text, click to view] Uri Dimant wrote:
> Hi > CREATE PROCEDURE usp_GetCompanyCode > @CompanyCode INT > AS > > BEGIN TRAN > > SELECT <columns> FROM TableName WITH (UPDLOCK,HOLDLOCK) > --Do here another operation > > COMMIT TRAN > > > > GO > > ---Usage > > EXEC usp_GetCompanyCode @CompanyCode =1000 > > > > > "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message > news:1159170935.933457.159040@m7g2000cwm.googlegroups.com... > > Others are also getting data from the DB at the same time. Also kindly > > if you can give me stored procedure code do give me I need it very > > badly. > > Uri Dimant wrote: > >> Hi > >> > >> > can communicate with that company. I want that if my syatem gives > >> > company record 1 to employee 1 then it should not be given to any other > >> > person. Can you guide me about stored procedure that can do this or is > >> > there any alternative way availabe for it. Ishall be very thankful to > >> > you. > >> > >> And others are just waiting or what? > >> > >> Again > >> BEGIN TRAN > >> COMMIT TRAN > >> will lock the session untill it the transaction will be commited or > >> rollback > >> > >> Another way I can think is to maintain an additon column to indicate > >> whether > >> the company ID has aleady given and doing an appropriate job for others > >> > >> > >> > >> > >> "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message > >> news:1159162220.441699.239370@d34g2000cwd.googlegroups.com... > >> > Actually I want that If my system gives one record to one person for > >> > modification or to do some work on it then record must not be given to > >> > any other. for example in this case I have a project for telemarkting. > >> > there are 3-4 person sitting in front of systems and have one shared > >> > DB. Now my project should gave them a Company's contact no so that they > >> > can communicate with that company. I want that if my syatem gives > >> > company record 1 to employee 1 then it should not be given to any other > >> > person. Can you guide me about stored procedure that can do this or is > >> > there any alternative way availabe for it. Ishall be very thankful to > >> > you. > >> > > >> > Uri Dimant wrote: > >> >> I'm not sure that understand your requirement > >> >> > >> >> BEGIN TRAN > >> >> > >> >> SELECT col FROM TableName (UPDLOCK,HOLDLOCK) > >> >> > >> >> > >> >> COMMIT TRAN > >> >> > >> >> Note, readers don't get blocked > >> >> > >> >> "Muhammad Ahsin Saleem" <ahsin.saleem@gmail.com> wrote in message > >> >> news:1159158795.894329.64950@m7g2000cwm.googlegroups.com... > >> >> > hi > >> >> > everyone I have a problem that I have an application having a shared > >> >> > DB > >> >> > and I want that when I retrieve a record from database for one > >> >> > machine > >> >> > then that record must be locked so that others couldnot modify that > >> >> > record. I need urgant help I shall be thankful to all of you if > >> >> > anybody > >> >> > can help me. > >> >> > > >> > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |