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

±¾ÈËдµÄµÚÒ»¸öPL/SQL¹ý³Ì

¿´µ½±ðÈËÔÚÂÛ̳µÄÌáÎÊ£º
Ò»¸ö±íµÄЧÂÊÎÊÌâ
½ñÌìÅöµ½2Õűí
1ÕÅ ÓÐ×Ö¶Î
±íAÓÐ
jtbh(¼ÒÍ¥±àºÅ) hzxm(»§Ö÷ÐÕÃû) hnbh(»§ÄÚ×î´ó±àºÅ) 
1000          ÕÅÈý            03
1001          ÕÔÁù..........................
±íBÓÐ
grbh£¨¸öÈ˱àºÅ=¼ÒÍ¥±àºÅ+2λ»§ÄÚ±àºÅ) xm(ÐÕÃû) gz(¹¤×Ê)
100001                          ÕÅÈý      1000
100002                          ÀîËÄ      1000
100003                          ÍõÎå      1000
2ÕűíÊý¾Ý¼¸Ê®W¡£¡£¡£¡£ÏÖÔÚÓÉÓÚ֮ǰά»¤²»ºÃ£¬±íAµÄ×î´ó±àºÅûÓиüУ¬ÀýÈç±íB 1001Õâ»§ÈËÓÐ4¸ö±àºÅ£¬100101£¬100102 £¬100103£¬100105ÕâÑù£¬µ«ÊÇÎÒ±íA»§ÄÚ×î´ó±àºÅ¿ÉÄÜÖ»µ½ÁË04£¬¶øÊµ¼ÊÉÏÒªµ½05£¬ÇëÎʸ÷λ´óÏÀÈçºÎ¸üÐÂÓÐЧÂÊ£¬ÎÒ×Ô¼ºÐ´Á˸öЧÂÊÌ«µÍÁË¡£¡£¡£¡£¡£
ÓÚÊÇдÁËÏÂÃæµÄ¹ý³Ì£¬µÚÒ»´Îд£¬¼Ç¼һÏ¡£
CREATE PROCEDURE update_for_csdner();
  CURSOR v_cursor IS SELECT MAX(substr(grbh, 4, 2)) hnbh, substr(grbh, 0, 4) jtbh from b GROUP BY substr(grbh, 0, 4);
  v_jtbh VARCHAR2(4);
  v_hnbh VARCHAR2(2);
BEGIN
  OPEN v_cursor;
  LOOP
    FETCH v_cursor INTO v_hnbh, v_jtbh;
    EXIT WHEN v_cursor%NOTFOUND;
    UPDATE A SET hnbh = v_hnbh WHERE jtbh = v_jtbh;
    COMMIT;
  END LOOP;
  CLOSE v_cursor;
END;


Ïà¹ØÎĵµ£º

SQL Êý¾ÝÀàÐÍ


Microsoft Access Êý¾ÝÀàÐÍ
Êý¾ÝÀàÐÍ
ÃèÊö
´æ´¢
Text
ÓÃÓÚÎı¾»òÎı¾ÓëÊý×ÖµÄ×éºÏ¡£×î¶à 255 ¸ö×Ö·û¡£
 
Memo
Memo ÓÃÓÚ¸ü´óÊýÁ¿µÄÎı¾¡£×î¶à´æ´¢ 65,536 ¸ö×Ö·û¡£
×¢ÊÍ£ºÎÞ·¨¶Ô memo ×ֶνøÐÐÅÅÐò¡£²»¹ýËüÃÇÊÇ¿ÉËÑË÷µÄ¡£
 
Byte
ÔÊÐí 0 µ½ 255 µÄÊý×Ö¡£
1 ×Ö½Ú
Integer
ÔÊÐí½éÓÚ -32,768 µ½ 32 ......

SQLÊý¾ÝÖÐÔËÐÐcmdÃüÁî

ÔÚsql²éѯ·ÖÎöÆ÷ÀïÃæÊDz»ÄÜÖ±½ÓÔËÐÐcmdÃüÁîµÄ
µ«ÊÇSQL¸ø³öÁËÒ»¸ö½Ó¿Ú
--´ò¿ª¸ß¼¶ÉèÖÃ
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
--´ò¿ªxp_cmdshellÀ©Õ¹´æ´¢¹ý³Ì
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE
Ê×ÏÈ ´ò¿ªÒ»Ð©ÅäÖÃ
È»ºóÖ´ÐÐÄãÒªÔËÐÐcmdÃüÁî
exec master..xp_cmdshell 'net star ......

×î½üµÄÁ½ÌõsqlЧÂÊÓÅ»¯ÐĵÃ

µÚÒ»Ìõ£º
select * from where field in (1,2,3)   ÕâÖÖд·¨Ó¦¸ÃÉáÆúÁË£¬¶øÓ¦¸ÃÕâÑùд£º
select * from table where field = 1 or field = 2 or field = 3 
ÎªÊ²Ã´ÄØ£¿
·²ÊÂÖ»ÓÐ×ö¹ý²ÅÖªµÀ£¬×Ô¼º½¨¸ö±í£¬²åÈë10WÌõ²âÊÔÊý¾Ý£¬ÓÃsql²âÊÔһϱãÖª£¬ÒòΪ¹¤×÷±ãÀû£¬ÎÒÔÚ²úÆ·»úºÍÍâÍø²âÊÔ»ú¶¼ÒѾ­²âÊÔ¹ý£ ......

C#.NET·ÀÖ¹SQL×¢Èëʽ¹¥»÷

1  ·ÀÖ¹sql×¢Èëʽ¹¥»÷(¿ÉÓÃÓÚUI²ã¿ØÖÆ£© #region  ·ÀÖ¹sql×¢Èëʽ¹¥»÷(¿ÉÓÃÓÚUI²ã¿ØÖÆ£©
  2 
  3   /**/ /// 
  4  ///  ÅжÏ×Ö·û´®ÖÐÊÇ·ñÓÐSQL¹¥»÷´úÂë
  5  /// 
  6  ///  ´«ÈëÓû§Ìá½»Êý¾Ý
  7  ///  ......

SQL learning

Five basic search conditions are summarized here:
1) Comparison test
2) Range test
3) Set membership test
4) Pattern matching test (Like)
     The pattern matching test checks to see whether the data value in a column matches a specified pattern
   % mathes any se ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ