DB2ÁÙʱ±íÔÚSQL¹ý³Ì
	
    
    
	  
°æÈ¨ÉùÃ÷£ºÔ´´×÷Æ·£¬ÈçÐè×ªÔØ£¬ÇëÓë×÷ÕßÁªÏµ¡£·ñÔò½«×·¾¿·¨ÂÉÔðÈΡ£
DB2ÁÙʱ±íÔÚSQL¹ý³ÌºÍSQLÓï¾äÖеIJâÊÔ×ܽá
 
²âÊÔÄ¿±ê£º
 
·Ö±ðÔÚSQL¹ý³ÌºÍSQLÓï¾äÖд´½¨ÁÙʱ±í£¬²¢²åÈëÊý¾Ý£¬¿´Ö´Ðнá¹ûÓÐʲôÒìͬ¡£
 
²âÊÔ»·¾³£º
 
DB2 UDB V9.1
 
Ö´Ðи½¼þÀïÃæµÄSQLÓï¾ä£¬µÃµ½Ò»¸ö±í¡£
 
 
²âÊÔ´úÂëºÍÔËÐнá¹û£º
 
Ò»¡¢ÁÙʱ±íÔÚSQLÓï¾äÖÐ
 
-- ¶¨ÒåÒ»¸öÈ«¾ÖÁÙʱ±íSESSION.RESULT
DECLARE GLOBAL TEMPORARY TABLE SESSION.RESULT
    (  
         TMP_HYDM   VARCHAR(10),    -- ÐÐÒµ´úÂë
         TMP_HYMC   VARCHAR(300)   -- ÐÐÒµÃû³Æ 
    )
     WITH REPLACE 
  NOT LOGGED;  
-- ²åÈëÊý¾Ýµ½ÁÙʱ±í    
INSERT INTO  SESSION.RESULT
SELECT MLDM,MLMC from DM_HY_CY;
 
-- ²éѯÁÙʱ±íÊý¾Ý    
SELECT * from SESSION.RESULT;
 
²âÊÔ½á¹û£ºÒÔÉÏSQL´úÂëÕý³£Ö´ÐУ¬µ«ÊÇûÓвéѯµ½ÈκÎÊý¾Ý¡£
 
 
¶þ¡¢ÁÙʱ±íÔÚSQL´æ´¢¹ý³ÌÖÐ
 
CREATE PROCEDURE SP_TEST_TMEP (  )
        DYNAMIC RESULT SETS 1
------------------------------------------------------------------------
-- ÓïÑÔ£ºDB2 SQL ´æ´¢¹ý³Ì 
 
-- ˵Ã÷£ºÓÃÀ´²âÊÔͨ¹ý²éѯ²åÈëÁÙʱ±íÊý¾Ý
-- ×÷ÕߣºÈÛ ÑÒ
-- ÈÕÆÚ£º2008-08-31
------------------------------------------------------------------------
P1: BEGIN
        -- ¶¨ÒåÒ»¸öÈ«¾ÖÁÙʱ±íSESSION.RESULT
        DECLARE GLOBAL TEMPORARY TABLE SESSION.RESULT
            (  
                        TMP_HYDM   VARCHAR(10),   -- ÐÐÒµ´úÂë
             &n
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
     ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓᣠ
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE) 
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT) 
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý ......
	
    
        
    
     1¡¢¹«Óñí±í´ïʽ (CTE) ¿ÉÒÔÈÏΪÊÇÔÚµ¥¸ö SELECT¡¢INSERT¡¢UPDATE¡¢DELETE »ò CREATE VIEW Óï¾äµÄÖ´Ðз¶Î§ÄÚ¶¨ÒåµÄÁÙʱ½á¹û¼¯¡£CTE ÓëÅÉÉú±íÀàËÆ£¬¾ßÌå±íÏÖÔÚ²»´æ´¢Îª¶ÔÏ󣬲¢ÇÒÖ»ÔÚ²éѯÆÚ¼äÓÐЧ¡£ÓëÅÉÉú±íµÄ²»Í¬Ö®´¦ÔÚÓÚ£¬CTE ¿É×ÔÒýÓ㬻¹¿ÉÔÚͬһ²éѯÖÐÒýÓöà´Î¡£
¡¡¡¡CTE ¿ÉÓÃÓÚ£º
¡¡¡¡´´½¨µÝ¹é²éѯ¡£ÓйØÏêϸР......
	
    
        
    
     Select * from tableName 
exec('select * from tableName') 
exec sp_executesql N'select * from tableName' -- Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN 
2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL 
declare @fname varchar(20) 
set @fname = 'FiledName' 
Select @fname from tableName -- ´íÎó,²»»áÌáʾ´í ......
	
    
        
    
    ÏÂÃæÊÇÎÒËѼ¯µÄһЩ¾«ÃîµÄSQLÓï¾ä¡£
˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb)
SQL: select * into b from a where 1<>1
˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý,Ô´±íÃû£ºa Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d,e,f from b;
˵Ã÷£ºÏÔʾÎÄÕ¡¢Ìá½»È˺Í×îºó»Ø¸´Ê±¼ä
SQL: select a.title,a.username,b.adddat ......