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

PL/SQL±¨ÎÞЧµÄ´°¿Ú¾ä±úµÄ½â¾ö°ì·¨

ÎÒÔÚʹÓÃPL/SQLʱ£¬µã»÷ij¸ö×Ö¶ÎÅԱߵÄС°´Å¥Ï£Íûµ¯³ö±à¼­´°¿Úʱ£¬PL/SQLÌáʾ“ÎÞЧµÄ´°¿Ú¾ä±ú”¡£Ò»Ö±²»Ã÷°×ÊÇÔõô»ØÊ£¬ºóÀ´baiduÁËÏ£¬²ÅÖªµÀÕâ¸ö¹¦ÄܺÍwindowsµÄprint spooler·þÎñÓйء£Æô¶¯¸Ã·þÎñ¾Í¿ÉÒÔÁË¡£


Ïà¹ØÎĵµ£º

³£ÓÃSQL×Ö·û´®º¯ÊýÓï·¨

×Ö·û´®º¯Êý¶Ô¶þ½øÖÆÊý¾Ý¡¢×Ö·û´®ºÍ±í´ïʽִÐв»Í¬µÄÔËËã¡£´ËÀຯÊý×÷ÓÃÓÚCHAR¡¢VARCHAR¡¢ BINARY¡¢ ºÍVARBINARY Êý¾ÝÀàÐÍÒÔ¼°¿ÉÒÔÒþʽת»»ÎªCHAR »òVARCHARµÄÊý¾ÝÀàÐÍ¡£¿ÉÒÔÔÚSelect Óï¾äµÄSelect ºÍWhere ×Ó¾äÒÔ¼°±í´ïʽÖÐʹÓÃ×Ö·û´®º¯Êý¡£³£ÓõÄ×Ö·û´®º¯ÊýÓУº 
    
     ......

Ñо¿Éú³ÉSQL½Å±¾

IF   OBJECT_ID('DataAsInsCommand')   IS   NOT   NULL   DROP   PROC   DataAsInsCommand  
  GO  
  SET   QUOTED_IDENTIFIER   OFF  
  GO  
  CREA ......

SQL SERVER2000 ±¸·ÝÎÊÌâ

         ÔÚSQL SERVER2000ÆóÒµ¹ÜÀíÆ÷Ï£¬SQL Server×éÀïÒѾ­¼ÓÈçÁË Ð½¨SQL Server ×¢²á
±ÈÈ磺ÔÚ¿ÉÓõķþÎñÆ÷(V)Îı¾¿òÖÐÊäÈëÁË:192.138.2.66È»ºóµã»÷ Ìí¼Óµ½·þÎñÆ÷£¬µ±×¢²á³É¹¦ºó
£¬µ±È»192.138.2.66ÀïÃæÓРһ¸öÃûΪ kangarooµÄÊý¾Ý¿â£¬ ÎÒÏÖÔÚµÄÎÊÌâÊÇ£º
 Ôõô°Ñ ......

Oracle PL/SQL¹ÜÀíLDAP·þÎñÆ÷(DBMS_LDAP°üµÄʹÓÃ)

Á˽âLDAP

LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊЭÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPЭÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......

sqlÖ®truncate ¡¢deleteÓëdropÇø±ð

truncate ¡¢deleteÓëdropÇø±ð
Ïàͬµã£º
truncate ºÍ²»´ø where ×Ó¾äµÄ delete£¬ÒÔ¼° drop ¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã£º
1. truncate ºÍ delete ֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
drop Óï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain)¡¢´¥·¢Æ÷(trigger)¡¢Ë÷Òý(index)£»ÒÀÀµÓڸñíµÄ´æ´¢¹ý³Ì/º¯Êý½«±£Áô,µ«ÊDZäΪ invalid ×´Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ