Click here to Skip to main content
14,457,064 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 4:10
cofounderChris Maunder16-Jul-09 4:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 17:30
cofounderChris Maunder10-Nov-05 17:30 
QuestionCreate a new Primary Key on survey table Pin
learning_new25-Feb-20 13:01
Memberlearning_new25-Feb-20 13:01 
QuestionMessage Closed Pin
11-Feb-20 23:33
professionalmodelinmumbaicity11-Feb-20 23:33 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 14:35
MemberSuper Lloyd5-Feb-20 14:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 16:09
professionalEddy Vluggen5-Feb-20 16:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 18:38
MemberSuper Lloyd5-Feb-20 18:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 3:50
professionalEddy Vluggen6-Feb-20 3:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 23:28
communityengineerJörgen Andersson5-Feb-20 23:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 1:17
communityengineerRichard Deeming6-Feb-20 1:17 
Questionintegrity constraint Pin
Tara112-Feb-20 7:23
MemberTara112-Feb-20 7:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:47
mveWendelius2-Feb-20 9:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 10:07
MemberTara112-Feb-20 10:07 
GeneralRe: integrity constraint Pin
markkuk3-Feb-20 0:48
Membermarkkuk3-Feb-20 0:48 
Questiontransaction recovery Pin
Tara112-Feb-20 6:46
MemberTara112-Feb-20 6:46 
AnswerRe: transaction recovery Pin
Eddy Vluggen3-Feb-20 4:00
professionalEddy Vluggen3-Feb-20 4:00 
QuestionCopy structure of all the tables of one database to another server Pin
Member 1473192331-Jan-20 5:58
MemberMember 1473192331-Jan-20 5:58 
AnswerRe: Copy structure of all the tables of one database to another server Pin
phil.o31-Jan-20 6:12
mvephil.o31-Jan-20 6:12 
AnswerRe: Copy structure of all the tables of one database to another server Pin
Eddy Vluggen3-Feb-20 4:01
professionalEddy Vluggen3-Feb-20 4:01 
Questionintegrity constraint Pin
Tara1129-Jan-20 11:36
MemberTara1129-Jan-20 11:36 
AnswerRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 11:56
MemberMycroft Holmes29-Jan-20 11:56 
GeneralRe: integrity constraint Pin
Tara1129-Jan-20 12:05
MemberTara1129-Jan-20 12:05 
GeneralRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 12:21
MemberMycroft Holmes29-Jan-20 12:21 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 10:01
mveWendelius2-Feb-20 10:01 
Tara11 wrote:
Why it would be unreasonable to declare an integrity constraint to that effect?

Mainly because integrity constraint operate on row-basis. Transactions then again ensure that the operation is completed as a whole even when multiple commands are affected.

But neither of these guarantee that the total sum is unaffected when money is transferred. If this would be a single table operation, a trigger could be utilized to do that check.

modified 2-Feb-20 15:32pm.

QuestionOracle SQL query to MS-SQL Pin
Member 951930620-Jan-20 23:37
MemberMember 951930620-Jan-20 23:37 

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

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