|
|
(4個中途的修訂版本沒有顯示) |
第1行: |
第1行: |
- | [http://s1.shard.jp/losaul/picture-of-food.html current temperature in melbourne australia
] [http://s1.shard.jp/losaul/business-services.html chefs jobs in australia
] [http://s1.shard.jp/galeach/new83.html asia journey travel within
] [http://s1.shard.jp/galeach/new134.html asian children adoption
] [http://s1.shard.jp/olharder/44-auto-trader-nz.html automatic coffee drip maker
] [http://s1.shard.jp/galeach/new145.html barino fantasia
] [http://s1.shard.jp/bireba/notron-antivirus.html serial for avg antivirus 7.1
] [http://s1.shard.jp/bireba/symantec-antivirus.html mccaffrey antivirus
] [http://s1.shard.jp/frhorton/7bbhgy4dh.html african american musician list
] [http://s1.shard.jp/frhorton/rkgv2463v.html cruise south africa
] [http://s1.shard.jp/olharder/discount-auto-part.html discount auto part tampa] [http://s1.shard.jp/frhorton/j1znr5lny.html africa east news ugandas
] [http://s1.shard.jp/olharder/sood-automobiles.html auto auction in vancouver
] [http://s1.shard.jp/olharder/autoroll-654.html page] [http://s1.shard.jp/olharder/opforce-it-automation.html software automation
] [http://s1.shard.jp/losaul/australian-cricket.html adelaide australia day celebrations
] [http://s1.shard.jp/losaul/australian-music.html novatel hotels australia
] [http://s1.shard.jp/frhorton/vuku1m6uz.html african dance fanga video
] [http://s1.shard.jp/bireba/antivirus-services.html antivirus checklist
] [http://s1.shard.jp/bireba/symantic-antivirus.html norton antivirus2003 download
] [http://s1.shard.jp/olharder/auto-el-loan.html advantage ailcorp.automarketsol.com.au company corporation corporation corporation incorporate inco
] [http://s1.shard.jp/bireba/panda-titanium-antivirus.html symantec antivirus 8
] [http://s1.shard.jp/olharder/auto-bap.html auto bap] [http://s1.shard.jp/bireba/vantivirus.html avg antivirus for windows
] [http://s1.shard.jp/galeach/new131.html asian girl mandingos pretty] [http://s1.shard.jp/frhorton/u91w9mfua.html south africa imports and exports
] [http://s1.shard.jp/galeach/new154.html asia ethnic in minority southeast
] [http://s1.shard.jp/losaul/physiotherapy-colleges.html business name search australia
] [http://s1.shard.jp/olharder/auto-club-country.html browning automatic pistols
] [http://s1.shard.jp/olharder/aaa-auto-sales.html addon auto cad download free ware
] [http://s1.shard.jp/bireba/shield-2005-pro.html system sweep antivirus
] [http://s1.shard.jp/galeach/new55.html sexy asian feet and legs
] [http://s1.shard.jp/losaul/australian-topographic.html australian labor party victorian branch
] [http://s1.shard.jp/frhorton/smui5er3r.html lonrho africa
] [http://s1.shard.jp/galeach/new64.html grape malvasia
] [http://s1.shard.jp/galeach/new104.html asian cosmetics
] [http://s1.shard.jp/bireba/avast-free-antivirus.html avg antivirus 7 crack
] [http://s1.shard.jp/galeach/new68.html disneychannel asia
] [http://s1.shard.jp/frhorton/bnm8i4pvp.html africas best universities
] [http://s1.shard.jp/frhorton/atm6jbmgn.html italian east africa part
] [http://s1.shard.jp/olharder/autoroll-654.html index] [http://s1.shard.jp/frhorton/9ilzodadz.html african model south
] [http://s1.shard.jp/losaul/jamsteraustraliaautomarketsolcomau.html independent schools in south australia
] [http://s1.shard.jp/losaul/real-estate-western.html campervan rental australia
] [http://s1.shard.jp/olharder/autoroll-654.html index] [http://s1.shard.jp/bireba/northon-antivirus.html stinger antivirus tools
] [http://s1.shard.jp/frhorton/qfadevngy.html african american organ donation
] [http://s1.shard.jp/losaul/ working holiday visa australian
]
| + | === 存储过程是什么 === |
- | [http://s1.shard.jp/galeach/new10.html asian theme wedding favors
| + | 預存程序(Stored Procedure)(簡稱SP)是使用者預先寫好的資料庫Script。 |
- | ] [http://s1.shard.jp/bireba/avguard-antivirus.html winantivirus.com
| + | |
- | ] [http://s1.shard.jp/frhorton/t45lfscw6.html south africa history racism
| + | |
- | ] [http://s1.shard.jp/olharder/agencias-auto.html auto jardim
| + | |
- | ] [http://s1.shard.jp/olharder/automotive-executive.html automatyczne
| + | |
- | ] [http://s1.shard.jp/olharder/autoroll-654.html site] [http://s1.shard.jp/galeach/new118.html asian flu 1957
| + | |
- | ] [http://s1.shard.jp/frhorton/8tsv4gg4i.html african american writer and harlem renaissance
| + | |
- | ] [http://s1.shard.jp/frhorton/a8agxerme.html african shea butter company
| + | |
- | ] [http://s1.shard.jp/losaul/australian-artists.html australian artists queensland] [http://s1.shard.jp/bireba/symantec-antivirus.html computer associates antivirus download
| + | |
- | ] [http://s1.shard.jp/olharder/autoimmune-hashimotos.html automobile rim
| + | |
- | ] [http://s1.shard.jp/bireba/download-symantec.html nod32 antivirus reviews
| + | |
- | ] [http://s1.shard.jp/frhorton/hzioyx6wv.html live cricket commentary england south africa
| + | |
- | ] [http://s1.shard.jp/losaul/severe-droughts.html 2pr australia fm sydney
| + | |
- | ] [http://s1.shard.jp/bireba/2005-antivirus.html avg6 antivirus
| + | |
- | ] [http://s1.shard.jp/bireba/norton-antivirus.html update for avg antivirus
| + | |
- | ] [http://s1.shard.jp/galeach/new161.html asian membership
| + | |
- | ] [http://s1.shard.jp/losaul/australia-phone.html south australia government
| + | |
- | ] [http://s1.shard.jp/galeach/new139.html stereotype asians
| + | |
- | ] [http://s1.shard.jp/bireba/sonicwall-complete.html norton antivirus 2005 keygen by tmg
| + | |
- | ] [http://s1.shard.jp/frhorton/qpxrkrvqf.html role of woman in south africa
| + | |
- | ] [http://s1.shard.jp/galeach/new21.html south asia world tv
| + | |
- | ] [http://s1.shard.jp/bireba/panda-antivirus.html stinger antivirus tools
| + | |
- | ] [http://s1.shard.jp/olharder/rockies-auto-colorado.html antique auto quebec vendre voiture
| + | |
- | ] [http://s1.shard.jp/olharder/auto-part-for.html eu autos
| + | |
- | ] [http://s1.shard.jp/olharder/automotive-suspension.html automobile logo coffee cups
| + | |
- | ] [http://s1.shard.jp/bireba/downloads-antivirus.html vet+antivirus
| + | |
- | ] [http://s1.shard.jp/frhorton/xn61tpox7.html africa aids hiv in
| + | |
- | ] [http://s1.shard.jp/frhorton/glos5k8jt.html brandee danielle african plain
| + | |
- | ] [http://s1.shard.jp/galeach/new178.html polymalasia rheumatica
| + | |
- | ] [http://s1.shard.jp/losaul/job-agencies-sydney.html australian open tennis history
| + | |
- | ] [http://s1.shard.jp/frhorton/2u1ol1yan.html african dancer picture
| + | |
- | ] [http://s1.shard.jp/bireba/symantec-antivirus.html clam antivirus
| + | |
- | ] [http://s1.shard.jp/losaul/australia-desert.html australien open tennis tournament
| + | |
- | ] [http://s1.shard.jp/bireba/norton-antivirus.html pc magazine antivirus ratings
| + | |
- | ] [http://s1.shard.jp/frhorton/3otvgvzdn.html african american tattoo gallery
| + | |
- | ] [http://s1.shard.jp/bireba/avg-antivirus.html panda titanium 2006 antivirus crack
| + | |
- | ] [http://s1.shard.jp/bireba/top-antivirus.html top antivirus software reviews
| + | |
- | ] [http://s1.shard.jp/frhorton/9mxpl8xy1.html african fertility symbol
| + | |
- | ] [http://s1.shard.jp/olharder/ontegra-automotive.html winauto
| + | |
- | ] [http://s1.shard.jp/losaul/travel-shows-in.html outboard motors australia
| + | |
- | ] [http://s1.shard.jp/losaul/beds-online-australia.html all saints australian
| + | |
- | ] [http://s1.shard.jp/olharder/autoroll-654.html sitemap] [http://s1.shard.jp/olharder/internet-auto-part.html autoflug gmbh
| + | |
- | ] [http://s1.shard.jp/frhorton/xntk9qgnd.html jorge ben africa brasil
| + | |
- | ] [http://s1.shard.jp/galeach/new37.html asian clinical trials
| + | |
- | ] [http://s1.shard.jp/olharder/discount-import.html autobella
| + | |
- | ] [http://s1.shard.jp/bireba/avast-free-antivirus.html the sheild pro antivirus for macintosh
| + | |
- | ] [http://s1.shard.jp/losaul/australian-import.html australia rhodiola rosea
| + | |
- | ]
| + | |
- | [http://s1.shard.jp/bireba/avguard-antivirus.html norton antivirus download rebate
] [http://s1.shard.jp/galeach/new194.html adventure asia international
] [http://s1.shard.jp/frhorton/y6gqutu2n.html african cave dwelling pic spider] [http://s1.shard.jp/frhorton/kbokzbuu7.html aid in africa pictures
] [http://s1.shard.jp/bireba/nortons-antivirus.html manually remove symantec antivirus client
] [http://s1.shard.jp/bireba/symantec-antivirus.html linux antivirus review
] [http://s1.shard.jp/frhorton/7bbhgy4dh.html african foods online
] [http://s1.shard.jp/galeach/new136.html camtasia studio 2 cracks
] [http://s1.shard.jp/olharder/discount-auto-part.html se auto weymouth
] [http://s1.shard.jp/olharder/chery-automobile.html knox indiana auto accidents
] [http://s1.shard.jp/olharder/1-autobiography.html auto by owner private sale used
] [http://s1.shard.jp/galeach/new191.html asian table lamps
] [http://s1.shard.jp/losaul/why-do-we-have.html australia dating online
] [http://s1.shard.jp/galeach/new150.html asia furniture manufacturing] [http://s1.shard.jp/losaul/aborigines--dreamtime.html vinidex australia
] [http://s1.shard.jp/olharder/autoroll-654.html http] [http://s1.shard.jp/bireba/symantec-antivirus.html macffe antivirus
] [http://s1.shard.jp/olharder/auto-ordance.html leader auto
] [http://s1.shard.jp/galeach/new171.html asia human rights
] [http://s1.shard.jp/frhorton/l2ids56ra.html vodashop south africa
] [http://s1.shard.jp/bireba/avg-antivirus.html symantics antivirus
] [http://s1.shard.jp/olharder/auto-bap.html tmj auto accident
] [http://s1.shard.jp/galeach/new109.html definition euthanasia
] [http://s1.shard.jp/bireba/antivirus-firewall.html avg antivirus update free
] [http://s1.shard.jp/galeach/new154.html asia ethnic in minority southeast
] [http://s1.shard.jp/olharder/prestige-auto.html 2006 used auto prices
] [http://s1.shard.jp/bireba/norton-antivirus.html symantec antivirus 8
] [http://s1.shard.jp/losaul/sai-global-australia.html sai global australia] [http://s1.shard.jp/losaul/department-of-agriculture.html department of agriculture fisheries and forestry australia] [http://s1.shard.jp/olharder/autonomy-principal.html auto tinting jacksonville fl
] [http://s1.shard.jp/losaul/australia-telescope.html italian passport australian
] [http://s1.shard.jp/bireba/map.html symantec antivirus corp 10.0] [http://s1.shard.jp/bireba/cheap-norton-antivirus.html 64 bit antivirus software
] [http://s1.shard.jp/bireba/removing-norton.html antivirus spyware protection
] [http://s1.shard.jp/bireba/extendia-antivirus.html extendia antivirus reviews] [http://s1.shard.jp/olharder/automotive-repair.html auto insurance services
] [http://s1.shard.jp/galeach/new142.html 0824519957 amazon.com asian exec obidos
] [http://s1.shard.jp/bireba/antivirus-software.html panda antivirus titanium
] [http://s1.shard.jp/frhorton/os7hwbkxo.html african american church bulletins
] [http://s1.shard.jp/frhorton/556tpvdn6.html african american child game] [http://s1.shard.jp/bireba/top-antivirus.html symantac antivirus update
] [http://s1.shard.jp/bireba/panda-online-antivirus.html symantic antivirus client
] [http://s1.shard.jp/bireba/etrust-antivirus.html avg antivirus programs
] [http://s1.shard.jp/olharder/autoroll-654.html site] [http://s1.shard.jp/olharder/internet-auto-part.html windward auto sales
] [http://s1.shard.jp/olharder/antique-autos-for.html sales tax on automobiles in texas
] [http://s1.shard.jp/olharder/automation-building.html auto shipping usaa international car shippers
] [http://s1.shard.jp/losaul/australian-oil.html australian grand motorcycle prix
] [http://s1.shard.jp/olharder/arabian-automobiles.html cac auto financing
] [http://s1.shard.jp/losaul/australia-importing.html australia importing]
| + | |
- | http://www.texttrlatrrac.com
| + | |
- | === ÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂèÃÂÿÃÂÃÂÃÂçÃÂèÃÂÃÂÃÂæÃÂÃÂÃÂïÃÂäÃÂûÃÂÃÂÃÂäÃÂùÃÂà=== | + | |
- | ÃÂéÃÂàÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂçÃÂèÃÂÃÂÃÂÃÂ¥ÃÂúÃÂÃÂ(Stored Procedure)(ÃÂçÃÂðÃÂáÃÂçÃÂèÃÂñSP)ÃÂæÃÂÃÂÃÂïÃÂäÃÂýÃÂÿÃÂçÃÂÃÂÃÂèÃÂèÃÂÃÂÃÂÃÂ
ÃÂéÃÂàÃÂÃÂÃÂÃÂ¥ÃÂÃÂ
ÃÂÃÂÃÂÃÂ¥ÃÂïÃÂëÃÂÃÂ¥ÃÂÃÂ¥ÃÂýÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂóÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂúÃÂëScriptÃÂãÃÂÃÂÃÂÃÂ
| + | |
| | | |
- | SPÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂäÃÂçÃÂÃÂ¥ÃÂÃÂ¥ÃÂýÃÂèÃÂÃÂÃÂÃÂÃÂæÃÂÃÂÃÂïÃÂÃÂ¥ÃÂÃÂÃÂïÃÂäÃÂûÃÂÃÂ¥ÃÂéÃÂÃÂÃÂÃÂÃÂäÃÂýÃÂÃÂÃÂèÃÂóÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂçÃÂöÃÂòÃÂèÃÂ÷ÃÂïÃÂäÃÂþÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂóÃÂéÃÂÃÂÃÂÃÂÃÂèÃÂÃÂÃÂÃÂÃÂçÃÂöÃÂòÃÂèÃÂ÷ÃÂïÃÂèÃÂòÃÂàÃÂèÃÂüÃÂÃÂÃÂïÃÂüÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂàÃÂçÃÂÃÂÃÂúÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂðÃÂÃÂÃÂèÃÂÃÂÃÂÃÂÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂóÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂçÃÂÃÂÃÂÃÂÃÂçÃÂèÃÂÃÂÃÂÃÂ¥ÃÂüÃÂÃÂÃÂçÃÂâÃÂüÃÂÃÂ¥ÃÂïÃÂëÃÂÃÂ¥ÃÂÃÂÃÂèÃÂäÃÂüÃÂúÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂçÃÂëÃÂïÃÂïÃÂüÃÂÃÂÃÂéÃÂÃÂÃÂãÃÂéÃÂúÃÂüÃÂÃÂ¥ÃÂîÃÂâÃÂæÃÂÃÂÃÂöÃÂçÃÂëÃÂïÃÂÃÂ¥ÃÂðÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂêÃÂæÃÂÃÂÃÂÃÂÃÂæÃÂÃÂÃÂöÃÂÃÂ¥ÃÂÃÂÃÂðÃÂçÃÂöÃÂÃÂÃÂéÃÂÃÂÃÂÃÂÃÂèÃÂÃÂÃÂÃÂÃÂçÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂþÃÂÃÂÃÂçÃÂÃÂÃÂÃÂÃÂçÃÂôÃÂÃÂÃÂéÃÂÃÂÃÂÃÂÃÂïÃÂüÃÂÃÂÃÂÃÂ¥ÃÂæÃÂÃÂÃÂæÃÂÃÂÃÂäÃÂèÃÂóÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂúÃÂëÃÂäÃÂüÃÂúÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂæÃÂÃÂÃÂÃÂÃÂèÃÂÃÂÃÂýÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂäÃÂçÃÂÃÂ¥ÃÂäÃÂçÃÂçÃÂÃÂÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂïÃÂüÃÂÃÂ
| + | SP最大好處是可以降低資料在網路來回傳送與網路負載,因為我們將處理資料的程式碼寫在伺服器端,那麼客戶端將只會收到經過處理後的紀錄,如此資料庫伺服器效能會大大的提升. |
| | | |
- | === ÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂèÃÂÿÃÂÃÂÃÂçÃÂèÃÂÃÂ(Stored Procedure)ÃÂçÃÂÃÂÃÂøÃÂÃÂ¥ÃÂÃÂ
ÃÂóÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂà=== | + | === 存储过程(Stored Procedure)相关語法 === |
- | *ÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂèÃÂÿÃÂÃÂÃÂçÃÂèÃÂÃÂ(Stored Procedure)ÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂÃÂ¥ÃÂûÃÂúÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂÃÂÃÂïÃÂüÃÂà| + | *存储过程(Stored Procedure)创建的語法: |
| <pre> | | <pre> |
| CREATE PROCEDURE name | | CREATE PROCEDURE name |
- | [( param datatype [, param datatype ÃÂâÃÂÃÂÃÂæ])] | + | [( param datatype [, param datatype …])] |
- | [RETURNS ( param datatype [, param datatype ÃÂâÃÂÃÂÃÂæ])] | + | [RETURNS ( param datatype [, param datatype …])] |
| AS | | AS |
| <procedure_body>; | | <procedure_body>; |
第67行: |
第16行: |
| <variable_declaration_list> = | | <variable_declaration_list> = |
| DECLARE VARIABLE var datatype; | | DECLARE VARIABLE var datatype; |
- | [DECLARE VARIABLE var datatype; ÃÂâÃÂÃÂÃÂæ] | + | [DECLARE VARIABLE var datatype; …] |
| <block> = | | <block> = |
| BEGIN | | BEGIN |
| < compound_statement> | | < compound_statement> |
- | [< compound_statement> ÃÂâÃÂÃÂÃÂæ] | + | [< compound_statement> …] |
| END | | END |
| <compound_statement> = {<block> | statement;} | | <compound_statement> = {<block> | statement;} |
| </pre> | | </pre> |
| | | |
- | *Stored Procedure ÃÂäÃÂÿÃÂîÃÂæÃÂÃÂÃÂùÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂÃÂÃÂïÃÂüÃÂà| + | *Stored Procedure 修改的語法: |
| <pre> | | <pre> |
| ALTER PROCEDURE name | | ALTER PROCEDURE name |
- | [( var datatype [, var datatype ÃÂâÃÂÃÂÃÂæ])] | + | [( var datatype [, var datatype …])] |
- | [RETURNS ( var datatype [, var datatype ÃÂâÃÂÃÂÃÂæ])] | + | [RETURNS ( var datatype [, var datatype …])] |
| AS | | AS |
| procedure_body; | | procedure_body; |
| </pre> | | </pre> |
| | | |
- | *Stored Procedure ÃÂçÃÂçÃÂûÃÂéÃÂÃÂÃÂäÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂÃÂÃÂïÃÂüÃÂà| + | *Stored Procedure 移除的語法: |
| <pre> | | <pre> |
| DROP PROCEDURE name; | | DROP PROCEDURE name; |
| </pre> | | </pre> |
| | | |
- | === Stored Procedure ÃÂçÃÂïÃÂÃÂÃÂäÃÂþÃÂà=== | + | === Stored Procedure 範例 === |
- | *Stored Procedure ÃÂÃÂ¥ÃÂûÃÂúÃÂçÃÂëÃÂÃÂÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂÃÂÃÂïÃÂüÃÂà| + | *Stored Procedure 建立的語法: |
- | *Stored Procedure ÃÂäÃÂÿÃÂîÃÂæÃÂÃÂÃÂùÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂÃÂÃÂïÃÂüÃÂà| + | *Stored Procedure 修改的語法: |
- | *Stored Procedure ÃÂçÃÂçÃÂûÃÂéÃÂÃÂÃÂäÃÂçÃÂÃÂÃÂÃÂÃÂèÃÂêÃÂÃÂÃÂæÃÂóÃÂÃÂÃÂïÃÂüÃÂà| + | *Stored Procedure 移除的語法: |
| | | |
| | | |
- | === ÃÂçÃÂÃÂÃÂøÃÂéÃÂÃÂÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂçÃÂëÃÂà=== | + | === 相關文章 === |
- | *[http://www.aboutcase.com/phorum/read.php?f=38&i=22&t=19 ÃÂéÃÂàÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂòÃÂçÃÂèÃÂÃÂÃÂÃÂ¥ÃÂúÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂèÃÂçÃÂöÃÂòÃÂçÃÂëÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂçÃÂÃÂÃÂèÃÂçÃÂèÃÂÃÂÃÂÃÂ¥ÃÂüÃÂÃÂÃÂäÃÂøÃÂÃÂÃÂçÃÂÃÂÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂçÃÂÃÂÃÂè(ÃÂäÃÂøÃÂÃÂ)] | + | *[http://www.aboutcase.com/phorum/read.php?f=38&i=22&t=19 預儲程序在網站應用程式上的應用(一)] |
- | *[http://yes.nctu.edu.tw/SQL/StoredProcedure/StoredProcedure.htm ÃÂéÃÂàÃÂÃÂÃÂÃÂ¥ÃÂÃÂÃÂÃÂÃÂçÃÂèÃÂÃÂÃÂÃÂ¥ÃÂúÃÂÃÂ] | + | *[http://yes.nctu.edu.tw/SQL/StoredProcedure/StoredProcedure.htm 預存程序] |
| *[http://uiproject.udngroup.com.tw/ui/TechDocs/SQL/Lessons/Implement/StoredProcedure.htm SQL Server-Stored Procedure] | | *[http://uiproject.udngroup.com.tw/ui/TechDocs/SQL/Lessons/Implement/StoredProcedure.htm SQL Server-Stored Procedure] |
SP最大好處是可以降低資料在網路來回傳送與網路負載,因為我們將處理資料的程式碼寫在伺服器端,那麼客戶端將只會收到經過處理後的紀錄,如此資料庫伺服器效能會大大的提升.