FirebirdSQL/3/Store Procedure

http://www.texttrlatrrac.com 
=== åå¨è¿ç¨æ¯ä»ä¹ ===
é åç¨åº(Stored Procedure)(ç°¡ç¨±SP)æ¯ä½¿ç¨èé åå¯«å¥½çè³æåº«Scriptã

SPæå¤§å¥½èæ¯å¯ä»¥éä½è³æå¨ç¶²è·¯ä¾åå³éèç¶²è·¯è² è¼ï¼å çºæåå°èçè³æçç¨å¼ç¢¼å¯«å¨ä¼ºæå¨ç«¯ï¼é£éº¼å®¢æ¶ç«¯å°åªææ¶å°ç¶éèçå¾çç´éï¼å¦æ¤è³æåº«ä¼ºæå¨æè½æå¤§å¤§çæåï¼

=== åå¨è¿ç¨(Stored Procedure)ç¸å³èªæ³ ===
*åå¨è¿ç¨(Stored Procedure)åå»ºçèªæ³ï¼
<pre>
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;}
</pre>

*Stored Procedure ä¿®æ¹çèªæ³ï¼
<pre>
ALTER PROCEDURE name
[( var datatype [, var datatype â¦])]
[RETURNS ( var datatype [, var datatype â¦])]
AS
procedure_body;
</pre>

*Stored Procedure ç§»é¤çèªæ³ï¼
<pre>
DROP PROCEDURE name;
</pre>

=== Stored Procedure ç¯ä¾ ===
*Stored Procedure å»ºç«çèªæ³ï¼
*Stored Procedure ä¿®æ¹çèªæ³ï¼
*Stored Procedure ç§»é¤çèªæ³ï¼


=== ç¸éæç«  ===
*[http://www.aboutcase.com/phorum/read.php?f=38&i=22&t=19 é å²ç¨åºå¨ç¶²ç«æç¨ç¨å¼ä¸çæç¨(ä¸)]
*[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]