Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PL/SQLÓαê±äÁ¿µÄµ÷ÓÃÓë×÷ΪÊä³ö²ÎÊýµÄÓ¦ÓÃ

      ½ñÌìÓиöѧÉúÎÊÎÒµ÷ÓðüÀïÃæ¾ßÓÐÓαêÀàÐ͵ÄÊä³ö²ÎÊý£¬¿ÉÊÇÔÚÓÃPL/SQL³ÌÐòµ÷ÓõÄʱºò¾ÓÈ»±¨³ö²ÎÊý¸öÊý»òÀàÐÍ´íÎóµÄÒì³£ÐÅÏ¢£¬ÓÚÊÇ×Ô¼ºÒ²ÊÔÁËһϣ¬¹ûÈ»Êdzö´íÁË¡£È»ºó¾Í×Ô¼º×ÁÄ¥ÁËһϡ¢²é²é×ÊÁϺÍÎÊÎÊͬÊ£¬Ô­À´ÎÊÌâÊǺܼòµ¥µÄ£¬ÏÈ¿´Ò»Ï³ÌÐòµÄ½á¹¹´úÂ룺
CREATE OR REPLACE PACKAGE Pkg_Student
IS
TYPE StudentType IS REF CURSOR RETURN TB_STUDENT%ROWTYPE;
PROCEDURE Pro_student
(
 pi_ClassId IN TB_STUDENT.CLASSID%TYPE,
 Po_student OUT StudentType
);
END Pkg_Student;
--ʵÏÖ°üÌå´úÂë
CREATE OR REPLACE PACKAGE BODY Pkg_Student
IS
PROCEDURE Pro_student
(
 pi_ClassId IN TB_STUDENT.CLASSID%TYPE,
 Po_student OUT StudentType
)
AS
BEGIN
  IF pi_ClassId=1 THEN
   OPEN Po_student FOR SELECT * from TB_STUDENT WHERE TB_STUDENT.CLASSID=1;
  ELSIF pi_ClassId=2 THEN
   OPEN Po_student FOR SELECT *from TB_STUDENT WHERE TB_STUDENT.CLASSID=2;
  ELSE
   OPEN Po_student FOR SELECT *from TB_STUDENT WHERE TB_STUDENT.CLASSID=3;
  END IF;
END;
END Pkg_Student;
--Ö´Ðе÷ÓðüÀïÃæµÄ´æ´¢¹ý³Ì
DECLARE
 TYPE StudentType IS REF CURSOR RETURN TB_STUDENT%ROWTYPE;
 v_student StudentType;
 v_ClassID TB_STUDENT.CLASSID%TYPE:=1;
BEGIN
 Pkg_Student.Pro_student(v_ClassID,v_student);
END;
ÏñÉÏÃæÄÇÑùÖ´Ðоͻá³öÏÖ²ÎÊý¸öÊý»òÀàÐÍ´íÎó£»ÓÚÊÇ£¬¾ÀÕýÁËһϴúÂëÈçÏ£º
DECLARE
 v_student Pkg_Student.StudentType;
 v_ClassID TB_STUDENT.CLASSID%TYPE:=1;
BEGIN
 Pkg_Student.Pro_student(v_ClassID,v_student);
END;
Ô­ÒòÈçÏ£º
   1¡¢StudentType±¾ÉíÊÇÔÚ°üÀïÃæÉùÃ÷ºÍÓ¦Óã¬Æä×÷ÓÃÓòÒ²ÔÚ°üÄÚ²¿¶øÒÑ£»
   2¡¢ÈôÍⲿ³ÌÐòÒªµ÷ÓðüÀïÃæ¾ßÓÐÓαêÀàÐͲÎÊýµÄ¹ý³Ì»òº¯Êýʱ£¬ÄÇô±ØÐëÔÚÍⲿÏÔʾµ÷Óðü
          ÀïÃæµÄÓαêÉùÃ÷£¬¶ø²»ÊÇÔÚÍâÃæÖØÐ¶¨ÒåÒ»¸öÓαêÉùÃ÷ºÍÓαê±äÁ¿¡£¶øÇÒ×¢ÒâµÄÊÇÓαê±äÁ¿±¾ÉíÒ²ÊǶ¯Ì¬µÄ£¬ÊÇÒ»¸öÒýÓÃÀàÐÍ£¬²»ÒÀÀµÓÚ¹¤×÷Çø¡£
ºÃÁË£¬¶ÔÓÚÕâ¸öÎÊÌâµÄ·ÖÎö¾Íµ½Õâ±ßÁË.........Ï£Íû¶Ô±ðÈËÓаïÖú¡££¨°ïÖúËûÈ˾ÍÊǰïÖú×Ô¼º£©


Ïà¹ØÎĵµ£º

sql±¸·ÝÊý¾Ý¿âÓï¾ä:SQL±¸·ÝÓï¾ä

--ÍêÕû±¸·Ý
Backup Database NorthwindCS
To disk='G:\Backup\NorthwindCS_Full_20070908.bak'
--²îÒ챸·Ý
Backup Database NorthwindCS
To disk='G:\Backup\NorthwindCS_Df_20070908.bak'
With Dferential
--ÈÕÖ¾±¸·ÝĬÈϽضÏÈÕÖ¾
Backup Log NorthwindCS
To disk='G:\Backup\NorthwindCS_Log_20070908. ......

sql °Ñ±íµ¼³É.TXTÎļþ

sql ´úÂë:
---------------------------------------------------------
/*
  a        ±íÃû
  Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
  " SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø± ......

Êý¾Ý¿â×Ö¶ÎÀàÐÍ SQL Server

—×Ö·ûÀàÐÍ
Char: ¶¨³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Varchar:±ä³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Text(varchar(max)):±ä³¤·ÇUnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ2G
Nchar:¶¨³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Nvarchar:±ä³¤UnicodeµÄ×Ö·ûÐÍÊý¾Ý£¬×î´ó³¤¶ÈΪ8000
Ntext(nvarchar(max)):± ......

SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ£¨zz£©

×ªÔØÒ»¸öBDBµÄÏà¹Ø½éÉÜ£¬»ù±¾¿ÉÒÔµ±ËÙ³ÉÊÖ²áÓ㬸ü¶àµÄÎĵµ¿ÉÒÔÈ¥Oracle¹Ù·½ÍøÕ¾ÏÂÔØ¡£
SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ
×÷ÕߣºMargo Seltzer
Oracle Berkeley DB Öг£Óà SQL º¯ÊýʹÓÃÖ¸ÄÏ¡£
2007 Äê 9 Ô·¢±í
³£³£ÓÐÈËÎÊ Oracle Berkeley DB “ÎÒÈçºÎÔÚ Berkeley DB ÖнøÐÐ <SQL ²éѯ>£¿"Òò´Ë£¬ÎÒÃÇ ......

db2 µ÷ÓÃsql½Å±¾³£ÓÃÃüÁî

db2 µ÷ÓÃsql½Å±¾³£ÓÃÃüÁdb2 -tf d:\creat_table.sql  Óë  db2 -td$ -f d:\creat_table.sql
db2 -tf d:\creat_table.sql µ÷Óýű¾ÃüÁîÊÇddl²Ù×÷ 
µ±Óöµ½sqlÓï¾ä¹ý³¤£¬»òÌáʾ DB21007E  ¶ÁÈ¡¸ÃÃüÁîʱÒѵ½´ïÎļþĩβ¡£¾ÍʹÓà db2 -td$ -f d:\creat_table.sql ÃüÁî
ʹÓøÄÃüÁîÐèÒªÔÚsql½Å±¾ÖÐÒÔ$½áÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ