FirebirdSQL/3/Store Procedure

[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Ã¦ÂÂÃ¥Â¤Â§Ã¥Â¥Â½Ã¨ÂÂÃ¦ÂÂ¯Ã¥ÂÂ¯Ã¤Â»Â¥Ã©ÂÂÃ¤Â½ÂÃ¨Â³ÂÃ¦ÂÂÃ¥ÂÂ¨Ã§Â¶Â²Ã¨Â·Â¯Ã¤Â¾ÂÃ¥ÂÂÃ¥ÂÂ³Ã©ÂÂÃ¨ÂÂÃ§Â¶Â²Ã¨Â·Â¯Ã¨Â²Â Ã¨Â¼ÂÃ¯Â¼ÂÃ¥ÂÂ Ã§ÂÂºÃ¦ÂÂÃ¥ÂÂÃ¥Â°ÂÃ¨ÂÂÃ§ÂÂÃ¨Â³ÂÃ¦ÂÂÃ§ÂÂÃ§Â¨ÂÃ¥Â¼ÂÃ§Â¢Â¼Ã¥Â¯Â«Ã¥ÂÂ¨Ã¤Â¼ÂºÃ¦ÂÂÃ¥ÂÂ¨Ã§Â«Â¯Ã¯Â¼ÂÃ©ÂÂ£Ã©ÂºÂ¼Ã¥Â®Â¢Ã¦ÂÂ¶Ã§Â«Â¯Ã¥Â°ÂÃ¥ÂÂªÃ¦ÂÂÃ¦ÂÂ¶Ã¥ÂÂ°Ã§Â¶ÂÃ©ÂÂÃ¨ÂÂÃ§ÂÂÃ¥Â¾ÂÃ§ÂÂÃ§Â´ÂÃ©ÂÂÃ¯Â¼ÂÃ¥Â¦ÂÃ¦ÂÂ¤Ã¨Â³ÂÃ¦ÂÂÃ¥ÂºÂ«Ã¤Â¼ÂºÃ¦ÂÂÃ¥ÂÂ¨Ã¦ÂÂÃ¨ÂÂ½Ã¦ÂÂÃ¥Â¤Â§Ã¥Â¤Â§Ã§ÂÂÃ¦ÂÂÃ¥ÂÂÃ¯Â¼Â

=== Ã¥ÂÂÃ¥ÂÂ¨Ã¨Â¿ÂÃ§Â¨Â(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]