PL/SQL±¨ÎÞЧµÄ´°¿Ú¾ä±úµÄ½â¾ö°ì·¨
ÎÒÔÚʹÓÃPL/SQLʱ£¬µã»÷ij¸ö×Ö¶ÎÅԱߵÄС°´Å¥Ï£Íûµ¯³ö±à¼´°¿Úʱ£¬PL/SQLÌáʾ“ÎÞЧµÄ´°¿Ú¾ä±ú”¡£Ò»Ö±²»Ã÷°×ÊÇÔõô»ØÊ£¬ºóÀ´baiduÁËÏ£¬²ÅÖªµÀÕâ¸ö¹¦ÄܺÍwindowsµÄprint spooler·þÎñÓйء£Æô¶¯¸Ã·þÎñ¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
×Ö·û´®º¯Êý¶Ô¶þ½øÖÆÊý¾Ý¡¢×Ö·û´®ºÍ±í´ïʽִÐв»Í¬µÄÔËËã¡£´ËÀຯÊý×÷ÓÃÓÚCHAR¡¢VARCHAR¡¢ BINARY¡¢ ºÍVARBINARY Êý¾ÝÀàÐÍÒÔ¼°¿ÉÒÔÒþʽת»»ÎªCHAR »òVARCHARµÄÊý¾ÝÀàÐÍ¡£¿ÉÒÔÔÚSelect Óï¾äµÄSelect ºÍWhere ×Ó¾äÒÔ¼°±í´ïʽÖÐʹÓÃ×Ö·û´®º¯Êý¡£³£ÓõÄ×Ö·û´®º¯ÊýÓУº
  ......
IF OBJECT_ID('DataAsInsCommand') IS NOT NULL DROP PROC DataAsInsCommand
GO
SET QUOTED_IDENTIFIER OFF
GO
CREA ......
ÔÚSQL SERVER2000ÆóÒµ¹ÜÀíÆ÷Ï£¬SQL Server×éÀïÒѾ¼ÓÈçÁË Ð½¨SQL Server ×¢²á
±ÈÈ磺ÔÚ¿ÉÓõķþÎñÆ÷(V)Îı¾¿òÖÐÊäÈëÁË:192.138.2.66È»ºóµã»÷ Ìí¼Óµ½·þÎñÆ÷£¬µ±×¢²á³É¹¦ºó
£¬µ±È»192.138.2.66ÀïÃæÓÐ Ò»¸öÃûΪ kangarooµÄÊý¾Ý¿â£¬ ÎÒÏÖÔÚµÄÎÊÌâÊÇ£º
Ôõô°Ñ ......
Á˽âLDAP
LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊÐÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPÐÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......
truncate ¡¢deleteÓëdropÇø±ð
Ïàͬµã£º
truncate ºÍ²»´ø where ×Ó¾äµÄ delete£¬ÒÔ¼° drop ¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã£º
1. truncate ºÍ delete ֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
drop Óï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain)¡¢´¥·¢Æ÷(trigger)¡¢Ë÷Òý(index)£»ÒÀÀµÓڸñíµÄ´æ´¢¹ý³Ì/º¯Êý½«±£Áô,µ«ÊDZäΪ invalid ×´Ì ......