FirebirdSQL/3/Store Procedure

出自VFP Wiki

（修訂版本間差異）
跳轉到: 導航, 搜尋
第1行： 第1行：
 +
[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  
http://www.texttrlatrrac.com  
-
=== 存储过程是什么 ===
+
=== 存储过程是什么 ===
-
預存程序(Stored Procedure)(簡稱SP)是使用者預先寫好的資料庫Script。
+
預存程序(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>;
第17行： 第18行：
<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]

在2009年5月26日 (二) 11:34所做的修訂版本

[http://s1.shard.jp/bireba/avguard-antivirus.html norton antivirus download rebate ] [http://s1.shard.jp/galeach/new194.html adventure asia international ] 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 ] asia furniture manufacturing [http://s1.shard.jp/losaul/aborigines--dreamtime.html vinidex australia ] 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 ] sai global australia 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 ] 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 ] 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 ] 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 ] 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 ] australia importing http://www.texttrlatrrac.com

目錄

存储过程是什么

預存程序(Stored Procedure)(簡稱SP)是使用者預先寫好的資料庫Script。

SP最大好處是可以降低資料在網路來回傳送與網路負載，因為我們將處理資料的程式碼寫在伺服器端，那麼客戶端將只會收到經過處理後的紀錄，如此資料庫伺服器效能會大大的提升．

存储过程(Stored Procedure)相关語法

  • 存储过程(Stored Procedure)创建的語法： 
CREATE PROCEDURE name
[( param datatype [, param datatype …])]
[RETURNS ( param datatype [, param datatype …])]
AS
<procedure_body>;
<procedure_body> = [<variable_declaration_list>]
<block>
<variable_declaration_list> =
DECLARE VARIABLE var datatype;
[DECLARE VARIABLE var datatype; …]
<block> =
BEGIN
< compound_statement>
[< compound_statement> …]
END
<compound_statement> = {<block> | statement;}
  • Stored Procedure 修改的語法： 
ALTER PROCEDURE name
[( var datatype [, var datatype …])]
[RETURNS ( var datatype [, var datatype …])]
AS
procedure_body;
  • Stored Procedure 移除的語法： 
DROP PROCEDURE name;

Stored Procedure 範例

  • Stored Procedure 建立的語法：
  • Stored Procedure 修改的語法：
  • Stored Procedure 移除的語法：


相關文章

取自"http://wiki.sunyear.com.tw/index.php?title=FirebirdSQL/3/Store_Procedure"