Click here to Skip to main content
11,711,220 members (82,528 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server
dear sir/ma'am
my software perform an update query .Now problem find is that two peoples perform the updation in exactly same time even no fraction in seconds so that the values updated two time but it in real update only one time .So sir how can i prevent such condition when there is no difference in the time even no difference in the seconds
Posted 12-Apr-13 21:12pm
OriginalGriff at 13-Apr-13 3:17am
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
If the same row is updated twice, it is updated twice and the second value will be used.
Use the "Improve question" widget to edit your question and provide better information.
AnkurGupta OM at 13-Apr-13 3:21am
sir question is that how can manage two transaction if both are performs same time even if no difference in the seconds
Maciej Los at 13-Apr-13 16:27pm
Sounds like bad table design.
Please, provide more details and describe table structure and what you want to achieve.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 549
1 OriginalGriff 255
2 Peter Leow 154
3 Maciej Los 120
4 Abhinav S 120
0 Maciej Los 95
1 Richard MacCutchan 90
2 Abhinav S 90
3 OriginalGriff 80
4 Member 4653839 50

Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 13 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100