Click here to Skip to main content
11,567,926 members (42,355 online)
   

Database

 
GeneralRe: What happens with auto-incremented value on rollback? Pin
PIEBALDconsult31-Jan-13 3:40
memberPIEBALDconsult31-Jan-13 3:40 
AnswerRe: What happens with auto-incremented value on rollback? Pin
gvprabu20-Feb-13 23:02
membergvprabu20-Feb-13 23:02 
QuestionBook recommendation for learning SQL Pin
Lloyd Atkinson29-Jan-13 18:33
memberLloyd Atkinson29-Jan-13 18:33 
AnswerRe: Book recommendation for learning SQL Pin
Jörgen Andersson30-Jan-13 0:52
memberJörgen Andersson30-Jan-13 0:52 
AnswerRe: Book recommendation for learning SQL Pin
i.j.russell30-Jan-13 4:34
memberi.j.russell30-Jan-13 4:34 
AnswerRe: Book recommendation for learning SQL Pin
Simon_Whale30-Jan-13 5:46
memberSimon_Whale30-Jan-13 5:46 
AnswerRe: Book recommendation for learning SQL Pin
djj5530-Jan-13 6:33
memberdjj5530-Jan-13 6:33 
AnswerRe: Book recommendation for learning SQL Pin
gvprabu20-Feb-13 23:09
membergvprabu20-Feb-13 23:09 
QuestionCan we delete old records from aspstatetempsessions table? Pin
manikantaer29-Jan-13 17:43
membermanikantaer29-Jan-13 17:43 
AnswerRe: Can we delete old records from aspstatetempsessions table? Pin
thatraja4-Oct-13 20:46
mvpthatraja4-Oct-13 20:46 
Questioncontrol AVG cost and close stock Pin
kornkimhour29-Jan-13 15:13
memberkornkimhour29-Jan-13 15:13 
AnswerRe: control AVG cost and close stock Pin
thatraja4-Oct-13 20:50
mvpthatraja4-Oct-13 20:50 
QuestionMySQL Table Lock Question Pin
Richard Andrew x6429-Jan-13 12:46
memberRichard Andrew x6429-Jan-13 12:46 
AnswerRe: MySQL Table Lock Question Pin
Jörgen Andersson30-Jan-13 10:34
memberJörgen Andersson30-Jan-13 10:34 
I don't know the answer either. (I would assume it waits)

But check if you can use named locks[^] instead, then your application can name the lock and check if another instance have made a lock with the same name or not.

But watch out, there are a lot of pitfalls. So read the manual properly.
People say nothing is impossible, but I do nothing every day.

QuestionSQL Update Pin
mrfalk29-Jan-13 11:24
membermrfalk29-Jan-13 11:24 
AnswerRe: SQL Update Pin
PIEBALDconsult29-Jan-13 11:47
memberPIEBALDconsult29-Jan-13 11:47 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:07
membermrfalk29-Jan-13 12:07 
AnswerRe: SQL Update Pin
Michael Potter29-Jan-13 11:50
memberMichael Potter29-Jan-13 11:50 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 11:59
memberPIEBALDconsult29-Jan-13 11:59 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 12:09
memberMycroft Holmes29-Jan-13 12:09 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 12:17
membermrfalk29-Jan-13 12:17 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:27
memberPIEBALDconsult29-Jan-13 12:27 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:49
memberMycroft Holmes29-Jan-13 13:49 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:20
memberPIEBALDconsult29-Jan-13 12:20 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:54
memberMycroft Holmes29-Jan-13 13:54 
GeneralRe: SQL Update Pin
jschell29-Jan-13 14:13
memberjschell29-Jan-13 14:13 
GeneralRe: SQL Update Pin
Michael Potter30-Jan-13 4:28
memberMichael Potter30-Jan-13 4:28 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 5:05
memberPIEBALDconsult30-Jan-13 5:05 
GeneralRe: SQL Update Pin
jschell30-Jan-13 7:58
memberjschell30-Jan-13 7:58 
GeneralRe: SQL Update Pin
PIEBALDconsult30-Jan-13 8:40
memberPIEBALDconsult30-Jan-13 8:40 
GeneralRe: SQL Update Pin
Michael Potter31-Jan-13 3:57
memberMichael Potter31-Jan-13 3:57 
GeneralRe: SQL Update Pin
PIEBALDconsult31-Jan-13 4:05
memberPIEBALDconsult31-Jan-13 4:05 
GeneralRe: SQL Update Pin
jschell31-Jan-13 8:01
memberjschell31-Jan-13 8:01 
AnswerRe: SQL Update Pin
PIEBALDconsult29-Jan-13 13:22
memberPIEBALDconsult29-Jan-13 13:22 
AnswerRe: SQL Update Pin
Jörgen Andersson30-Jan-13 1:21
memberJörgen Andersson30-Jan-13 1:21 
AnswerRe: SQL Update Pin
mrfalk30-Jan-13 6:20
membermrfalk30-Jan-13 6:20 
QuestionDatabase backup size Pin
savbace28-Jan-13 22:45
membersavbace28-Jan-13 22:45 
AnswerRe: Database backup size Pin
Richard Deeming29-Jan-13 1:21
memberRichard Deeming29-Jan-13 1:21 
QuestionSQL Server 2005 Express running slow ? Pin
Member 245846728-Jan-13 15:56
memberMember 245846728-Jan-13 15:56 
AnswerRe: SQL Server 2005 Express running slow ? Pin
PIEBALDconsult28-Jan-13 16:11
memberPIEBALDconsult28-Jan-13 16:11 
AnswerRe: SQL Server 2005 Express running slow ? Pin
Mycroft Holmes28-Jan-13 17:02
memberMycroft Holmes28-Jan-13 17:02 
AnswerRe: SQL Server 2005 Express running slow ? Pin
JOAT-MON29-Jan-13 11:09
memberJOAT-MON29-Jan-13 11:09 
QuestionCombining Data From Temp Tables Pin
Matt U.28-Jan-13 8:46
memberMatt U.28-Jan-13 8:46 
AnswerRe: Combining Data From Temp Tables Pin
David Mujica28-Jan-13 9:13
memberDavid Mujica28-Jan-13 9:13 
GeneralRe: Combining Data From Temp Tables Pin
Matt U.28-Jan-13 9:54
memberMatt U.28-Jan-13 9:54 
GeneralRe: Combining Data From Temp Tables Pin
Jörgen Andersson28-Jan-13 11:18
memberJörgen Andersson28-Jan-13 11:18 
GeneralRe: Combining Data From Temp Tables Pin
Matt U.28-Jan-13 12:13
memberMatt U.28-Jan-13 12:13 
GeneralRe: Combining Data From Temp Tables Pin
Mycroft Holmes28-Jan-13 12:00
memberMycroft Holmes28-Jan-13 12:00 
GeneralRe: Combining Data From Temp Tables Pin
Matt U.28-Jan-13 12:16
memberMatt U.28-Jan-13 12:16 
AnswerRe: Combining Data From Temp Tables Pin
Jörgen Andersson28-Jan-13 22:57
memberJörgen Andersson28-Jan-13 22:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150624.2 | Last Updated 29 Jun 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid