ÓÐÓõÄsqlÓï¾ä
¡¡¡¡Ëæ»ú¶ÁÈ¡Èô¸ÉÌõ¼Ç¼£¬²âÊÔ¹ý
AccessÓï·¨£ºSELECT top 10 * from ±íÃû ORDER BY Rnd(id)
Sql server:select top n * from ±íÃû order by newid()
mysql select * from ±íÃû Order By rand() Limit n
¡¡¡¡ËµÃ÷£ºÑ¡Ôñ´Ó10µ½15µÄ¼Ç¼
select top 5 * from (select top 15 * from table order by id asc) table_±ðÃû order by id desc
¡¡¡¡¸ù¾ÝÒÑÓÐµÄ±í´´½¨ÐÂ±í£º
A£ºcreate table tab_new like tab_old (ʹÓÃ¾É±í´´½¨Ð±í)
B£ºcreate table tab_new as select col1,col2… from tab_old definition only
1¡¢ËµÃ÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb) (Access¿ÉÓÃ)
¡¡¡¡·¨Ò»£ºselect * into b from a where 1<>1
¡¡¡¡·¨¶þ£ºselect top 0 * into b from a
2¡¢ËµÃ÷£º¿½±´±í(¿½±´Êý¾Ý,Ô´±íÃû£ºa Ä¿±ê±íÃû£ºb) (Access¿ÉÓÃ)
insert into b(a, b, c) select d,e,f from b;
3¡¢ËµÃ÷£º¿çÊý¾Ý¿âÖ®¼ä±íµÄ¿½±´(¾ßÌåÊý¾ÝʹÓþø¶Ô·¾¶) (Access¿ÉÓÃ)
insert into b(a, b, c) select d,e,f from b in ‘¾ßÌåÊý¾Ý¿â’ where Ìõ¼þ
¡¡¡¡Àý×Ó£º..from b in '"&Server.MapPath(".")&"\data.mdb" &"' where..
˵Ã÷£º¼¸¸ö¸ß¼¶²éѯÔËËã´Ê
¡¡¡¡A£º UNION ÔËËã·û
¡¡¡¡UNION ÔËËã·ûͨ¹ý×éºÏÆäËûÁ½¸ö½á¹û±í£¨ÀýÈç TABLE1 ºÍ TABLE2£©²¢ÏûÈ¥±íÖÐÈκÎÖØ¸´ÐжøÅÉÉú³öÒ»¸ö½á¹û±í¡£µ± ALL Ëæ
UNION Ò»ÆðʹÓÃʱ£¨¼´ UNION ALL£©£¬²»Ïû³ýÖØ¸´ÐС£Á½ÖÖÇé¿öÏ£¬ÅÉÉú±íµÄÿһÐв»ÊÇÀ´×Ô TABLE1 ¾ÍÊÇÀ´×Ô TABLE2¡£
¡¡¡¡B£º EXCEPT ÔËËã·û
¡¡¡¡EXCEPT ÔËËã·ûͨ¹ý°üÀ¨ËùÓÐÔÚ TABLE1 Öе«²»ÔÚ TABLE2 ÖеÄÐв¢Ïû³ýËùÓÐÖØ¸´ÐжøÅÉÉú³öÒ»¸ö½á¹û±í¡£µ± ALL Ëæ EXCEPT Ò»ÆðʹÓÃʱ (EXCEPT ALL)£¬²»Ïû³ýÖØ¸´ÐС£
¡¡¡¡C£º INTERSECT ÔËËã·û
¡¡¡¡INTERSECT ÔËËã·ûͨ¹ýÖ»°üÀ¨ TABLE1 ºÍ TABLE2 Öж¼ÓеÄÐв¢Ïû³ýËùÓÐÖØ¸´ÐжøÅÉÉú³öÒ»¸ö½á¹û±í¡£µ± ALL Ëæ INTERSECT Ò»ÆðʹÓÃʱ (INTERSECT ALL)£¬²»Ïû³ýÖØ¸´ÐС£
¡¡¡¡×¢£ºÊ¹ÓÃÔËËã´ÊµÄ¼¸¸ö²éѯ½á¹ûÐбØÐëÊÇÒ»Öµġ£
20¡¢ËµÃ÷£ºÁгöÊý¾Ý¿âÀïËùÓеıíÃû
select name from sysobjects where type='U'
21¡¢ËµÃ÷£ºÁгö±íÀïµÄËùÓеÄ
select name from syscolumns where id=object_id('TableName')
-----------------------------´æ´¢¹ý³Ì-----------------------------------
-(1)ÎÞ²Î
Ïà¹ØÎĵµ£º
1.¹ØÓÚÊý¾Ý¿â¹¹¼ÜÌåϵ
¢Ù±í¿Õ¼äµÄ¼à¿ØÊÇÒ»¸öÖØÒªµÄÈÎÎñ£¬ÎÒÃDZØÐëʱ¿Ì¹ØÐıí¿Õ¼äµÄÉèÖã¬ÊÇ·ñÂú×ãÏÖÔÚÓ¦
ÓõÄÐèÇó£¬ÒÔϵÄÓï¾ä¿ÉÒÔ²éѯµ½±í¿Õ¼äµÄÏêϸÐÅÏ¢¡£
SQL code
SELECT TABLESPACE_NAME,
INITIAL_EXTENT,
NEXT_EXTENT,
&nb ......
ÓÐʱ£¬ ΪÁËÈÃÓ¦ÓóÌÐòÔËÐеøü¿ì£¬Ëù×öµÄÈ«²¿¹¤×÷¾ÍÊÇÔÚÕâÀï»òÄÇÀï×öһЩºÜСµ÷Õû¡£°¡£¬µ«¹Ø¼üÔÚÓÚÈ·¶¨ÈçºÎ½øÐе÷Õû£¡³ÙÔçÄú»áÓöµ½ÕâÖÖÇé¿ö£ºÓ¦ÓóÌÐòÖÐµÄ SQL ²éѯ²»Äܰ´ÕÕÄúÏëÒªµÄ·½Ê½½øÐÐÏìÓ¦¡£ËüҪô²»·µ»ØÊý¾Ý£¬ÒªÃ´ºÄ·ÑµÄʱ¼ä³¤µÃ³öÆæ¡£Èç¹ûËü½µµÍÁ˱¨¸æ»òÄúµÄÆóÒµÓ¦ÓóÌÐòµÄËÙ¶È£¬Óû§±ØÐëµÈ´ýµÄʱ¼ä¹ý³¤£¬ËûÃǾͻá ......
FileStream:ÎļþÁ÷,ΪÁ˽â¾ö´ó¶ÔÏóBLOB(Binary Large Objects)µÄ´æ´¢ÎÊÌâ.¶ÔÓÚ´ó¶ÔÏó´æ´¢,²¢ÇÒ²»ÊÜ2GBµÄÏÞÖÆ.
ÒÔÍùÓÐÁ½ÖÖ·½Ê½:
(1)´æ´¢ÔÚÊý¾Ý¿âÀïÃæ,ÕâÖÖ·½Ê½Ò»°ãʹÓÃimage×Ö¶Î,»òÕßvarbinary(max)À´×ö,ºÃ´¦ÊÇ¿ÉÒÔͳһ±¸·Ý,µ«Êµ¼ÊЧÂʽϵÍ;
(2)´æ´¢ÔÚÎļþϵͳ,¶øÊý¾Ý¿âÖд洢Îļþ·¾¶,ÕâÖÖ·½Ê½Êý¾Ý¿âѹÁ¦¼õÇáÁË,µ«È´²»·½ ......
Á˽âLDAP
LDAPÊÇLight Directory Access ProtocolÇáÁ¿¼¶Ä¿Â¼·ÃÎÊÐÒéµÄ¼ò³Æ£¬LDAPÓëÊý¾Ý¿âÓкܴóµÄÇø±ð£¬ËüµÄÊý¾ÝÊÇÊ÷×´µÄ£¬¶øÇÒÿ¸ö½ÚµãµÄÊôÐÔÒ²±È½Ï¹Ì¶¨¡£
LDAPÐÒéÖÐÓÃdn±íʾһÌõ¼Ç¼µÄλÖã¬dc±íʾһÌõ¼Ç¼ËùÊôÇøÓò£¬ou±íʾһÌõ¼Ç¼ËùÊô×éÖ¯£¬cn±íʾһÌõ¼Ç¼µÄÃû³Æ£¬uid±íʾһÌõ¼Ç¼µÄID£¬ÆäÖÐdnÊǸù¾ ......