资源描述：
《使用sql server存储过程实现银行转账业务（using sql server stored procedure to implement bank transfer service）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、使用sqlserver存储过程实现银行转账业务（UsingSQLserverstoredproceduretoimplementbanktransferservice）UsingSQLSERVERstoredprocedurestoimplementbanktransferservices2009-04-3012:10:11
2、classification:
3、report
4、namesubscriptionoperationframeworkInthebankingandfinancialsystem,weoftenhavetorealizesuchbanktransferope
5、rations,andthefinancialsystemconcurrencyisquitehigh,theneedtoconsiderhowtoimprovetheperformanceandensuresafetyandotherrelatedissues.Usingstoredprocedurestoimplementbanktransfersisagoodchoice.ThestoredproceduresintheSQLSERVERdatabasedealwiththeadvantagesanddisadvantagesoftheTransact-SQLlangu
6、agerelativetotheapplication:Advantage：1.thestoredprocedurehasbeenregisteredontheserver,precompiled,storedproceduresprecompiled,placedinthedatabase,andreducedthetimetakentocompilethestatement2.storedprocedurescanbeusedtoreducenetworktraffic,thestoredprocedurecodestoreddirectlyinthedatabase,w
7、hentheexecutionoftheapplicationonlyneedtotransferparameters,withouttheneedforaT-SQLcodetransfertothedatabase.3.highreusability,astorageprocessthatcanbeinvokedatdifferentlocationsinyourapplication.4.highmaintainability,theoperationoftheentirebusinesspackagetogethertodocodereplacementoperatio
8、nandapplicationinthedaysafterthecontinuousmaintenance,willleadtotheTrancSQLprocedurecodewillbecomemoreandmorecomplex,atthesametime,theupdatestoredprocedureisusuallyeasiertoupdatetheapplication,theprocedureshouldbeupdatedyouneedtocompile,deploy.5.usecachingtoimproveperformance,andthecompiled
9、storedproceduregoesdirectlyintotheSQLSERVERcache,enablingimmediateinvocationatthenextexecution.InSQLSERVER2005,theexecutionplanhasbeencachedforallT-SQLbatches,andtheefficiencyandstorageprocessisalmostthesame.6.enforcethesecurityauthenticationmechanismindatabasetoimprovethesecurityofapplicat
10、ion:(a)authorizationofstoredprocedurestospecificusers,aswellasaccesstospecificdata.B)enhancedcodesecuritythateffectivelypreventsSQLinjectionbypassingarguments.Shortcoming:1.poorportabilityA)becausethestoredprocedurebindstheapplicationtoSQLServer,encapsul
