资源描述：
《事务处理控制（transaction control）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、事务处理控制（Transactioncontrol）Transactioncontrol.Txtfirstlaughbecauseyoumeet,thefirstcryisbecauseyouarenot,thefirstsmiletears,becauseyoucannothave.targetIfyou'reatemporaryuser,onlyoccasionallyusingSQLtogetdatafromthedatabase,thenthefirsttendaysThetopichasprovi
2、dedyouwithenoughcontent,butifyouwanttodevelopit,youcanrunitinadatabasesystemProfessionalapplications,whichareverycommonatthemoment,arecontentcontrolsecuritythatyou'retalkingaboutinthenextfourdaysEmbeddedSQLstatementdatabaseprocesswillbeveryhelpfultoyou,wes
3、tartfromtransactioncontroltotodayAttheend,we'lllearnthefollowing?basictransactioncontrolHowtoconfirmorterminateatransaction?WhatisthedifferencebetweenSybaseandOracleintransactionprocessing?Intoday'sexample,weusePERSONALORACLE7andSYBASESQLSERVERforyouTheint
4、erpreterusedherelooksatthehelpdocumentationtofindoutwhattheyaredifferentTransactioncontrolTransactioncontrolortransactionprocessingreferstotheabilityofarelationaldatabasesystemtoexecutedatabasetransactionsTheunitperiodofacommandsequencethatmustbecompletedi
5、sthebeginningandendofthetransaction,ifitisinthetransactionTheerrorintheprocess,thenthewholeprocesscanbeterminatedaccordingtoneed,ifeverythingisright,thentheresultItwillbesavedintothedatabaseThedayafteryoumayruninthenetworkmultiuserapplicationclient/servere
6、nvironmentisdesignedforthis.SQL21dayselftaught(V1.0)interpreterstupidpigTwohundredandtwenty-fourAunifiedserver,suchasadatabaseserver,supportsmultipleworkstationsconnectedtoit,justlikeothertechnologiesThisimprovesthecomplexityofthedatabase,andthefollowingse
7、ctionsdescribetheapplicationthatabankusesBankapplicationSupposeyouwerehiredbythefederalbankandwereresponsiblefordesigningachequemanagementsystemforthem,youhavedesignedaveryTheperfectdatabaseandfrequentlytestedverifythatitiscorrect.Afteryoucallitintheapplic
8、ation,yougetit20yuanintheaccountandverified,thedatabasehasactuallylessthan20yuan,youhavestoredintheaccount50.25Theresultofverificationisthesameasexpected,soyou'reproudtotellyourbosshowmanysystemscanrunThecomp
