using Transaction query how to commit only one record

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

i ma read this record

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
BEGIN TRANSACTION;

SELECT * FROM macntmst where ACODE ='A0052'

SELECT * FROM macntmst where ACODE ='A0051'

COMMIT TRANSACTION;

don't allow to update this record other person record

update pharma.dbo.macntmst set ACCAT =00200001 where ACODE ='6101'

Posted 21-Jul-14 19:37pm

manoj s sherje

Add a Solution

Comments

Maciej Los 22-Jul-14 1:53am

Sorry, not clear! We can't read in your mind or direct from your screen. Please, be more specific and provide more details.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kumarbs · Answer 1 · 2014-07-22T19:15:00

Solution 1

I understand that you need to update the record within the transaction, if it so , try to put that update query within the transaction.

BEGIN TRANSACTION;
update pharma.dbo.macntmst set ACCAT =00200001 where ACODE ='6101'
COMMIT TRANSACTION;

Posted 22-Jul-14 19:15pm

Kumarbs

Comments

manoj s sherje 24-Jul-14 0:47am

no sir actually i want to tell if any one select this record other person cant not be change this record

Kumarbs 24-Jul-14 1:43am

Ok. You can put that record in the transaction, until unless you commit/rollback that record no one is available to access that record.