SQLÓïÑÔ»ù´¡£¨2£©
from×Ó¾äÖ¸¶¨ÐèÒª½øÐÐÊý¾Ý²éѯµÄ±í£¬ÊÓͼµÈÊý¾ÝÔ´£¬ÓöººÅ·Ö¸ô¡£
from×Ӿ仹¿ÉÒÔÖ¸¶¨Êý¾Ý±í»òÊÓͼ֮¼äµÄÁ¬½ÓÀàÐÍ£¬ÀàÐÍÈ¡¾öÓÚon×Ó¾äÖÐÖ¸¶¨µÄÁ¬½ÓÌõ¼þ¡£
T-SQL¿ÉÒÔÖ§³ÖÔÚfrom×Ó¾äÖÐÖ¸¶¨³ýÊý¾Ý±í»òÊÓͼÍâµÄÆäËû¶ÔÏó¹¹³ÉÅÉÉú±í¡£
ÀýÈ磺select emp.Ô±¹¤±àºÅ£¬emp.Ô±¹¤ÐÕÃû£¬sp.²¿ÃÅÃû³Æ
from Ô±¹¤Êý¾Ý±í as emp
(select ²¿ÃÅÊý¾Ý±í.²¿ÃűàºÅ£¬²¿ÃÅÊý¾Ý±í.²¿ÃÅÃû³Æ
from ²¿ÃÅÊý¾Ý±í
where ²¿ÃÅÊý¾Ý±í.²¿ÃűàºÅ>2)as sp
where emp.²¿ÃűàºÅ=sp.²¿ÃűàºÅ£»
¼ìË÷³ö¸ß¼¶²¿ÃÅ£¨²¿ÃűàºÅ´óÓÚ2£©µÄÔ±¹¤¡£
where×Ó¾äÖ¸¶¨Êý¾ÝµÄ¼ìË÷Ìõ¼þ
±È½ÏÔËËã·û£º<,<=,>,>=,=,!=,!<,!>;
·¶Î§ËµÃ÷£ºbetween a and b£¬not between a and b£»
¿ÉÑ¡ÖµÁÐ±í£ºIN£¬NOT IN dept_id in('1001','1002')
ģʽƥÅ䣺like£¬not like
ÊÇ·ñ¿ÕÖµ£ºis null£¬is not null
Ìõ¼þÂß¼×éºÏ£ºand£¬or£¬not
±È½Ï²éѯÌõ¼þ£ºtext£¬ntextºÍimageÊé¼®ÀàÐͲ»ÄÜÓë±È½ÏÔËËã·û×é³É²éѯÌõ¼þ
Áбí²éѯÌõ¼þ£ºin¹Ø¼ü×Ö´ó¶àÓÃÓÚǶÌײéѯÖУ¬ÎªselectÑ¡¶¨·¶Î§
ģʽƥÅ䣺*Æ¥ÅäÈÎÒâ×Ö·û´®£¬£¿Æ¥ÅäÈÎÒâÒ»¸ö×Ö·û£¬´óСдÃô¸Ð£»%ÓÉ0¸ö»òÈÎÒâ×Ö·û´®£»_±íʾµ¥¸ö×Ö·û£¬Ò»¸öºº×ÖÒªÖ¸¶¨Á½¸ö×Ö·û£»[]ÓÃÓÚÖ¸¶¨·¶Î§[a-f]£¬[^]Ö¸¶¨·¶Î§ÍâµÄ×Ö·û[^a-f];
like'%en%'.....,µ±×Ö·û´®±¾Éí°üÀ¨Í¨Åä·û£¬ÈçSQL_MAIL£¬like‘SQL#_M_IL’ESCAPE‘#’£¨#Ò²¿ÉÒÔ»»³É±ðµÄ·ûºÅ£©»òʹÓÃ[]½«Í¨Åä·ûÖ¸¶¨ÎªÆÕͨ×Ö·û¡£
Ïà¹ØÎĵµ£º
MS SQL SERVERÊý¾Ý¿â±¸·ÝBAK»¹ÔÊý¾Ý¿â
ÓÉÓÚÊý¾ÝÎó²Ù×÷£¬Ïë»Ö¸´Ò»Ï²Ù×÷Ç°µÄÊý¾Ý¡£ÓÚÊÇн¨ÁËÒ»¸ö¿ÕÊý¾Ý¿â¡£Ê¹ÓÃÔÀ´µÄ±¸·ÝÎļþ bak¡£À´»Ö¸´³ÉÒ»¸öеÄÊý¾Ý¿â¡£ÕâÑù¾Í¿ÉÒÔÊÖ¶¯»Ö¸´Êý¾ÝÁË¡£
µ«ÊÇÔÚ»Ö¸´Ð½¨Êý¾Ý¿âµÄʱºò×ÜÊDz»³É¹¦£¬Ìáʾ´íÎóÈëÏ£º
The backup set holds a backup of a database other than the existing ......
Knowledge Xpert® for PL/SQL ÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄ»ùÓÚWindowsµÄ¼¼Êõ×ÊÔ´¿â£¬Ëü¸²¸ÇPL/SQL ¿ª·¢µÄÕû¸öÉúÃüÖÜÆÚ£¬ÉÏǧÖÖרÌâÌṩ±àд¸ßÖÊÁ¿´úÂëËùÐèÒªµÄ±³¾°ÐÅÏ¢¡¢×îºÃµÄ¾ÑéºÍ³ÌÐò·¶Àý¡£
ÌṩÉÏǧÖÖרÌ⣬¸²¸ÇPL/SQL ±à³ÌµÄÕû¸öÉúÃüÖÜÆÚ£¬´Ó»ù±¾µÄרÌâµ½¸ß¼¶µÄPL/SQL ±àÂë¼¼Êõ¡£
ÓÉ°üÀ¨Mike Ault¡¢Steven Feuerstein¡¢ ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......
ÐÞ¸ÄÊý¾Ý¿â¶ÔÏóËùÓÐÈË
½ñÌì°ïÅóÓÑ´«Êý¾Ý¿â±¨´í,Ìáʾ "
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]µÇ½ xxx ʧ°Ü",ÕýºÃÇ°¶Îʱ¼äÅöµ½Í¬ÑùÎÊÌâ,³¢ÊÔɾ³ýÓû§ xxx , ÓÖ±¨´í,Ìáʾ" Óû§ÓµÓжÔÏó,ËùÒÔÎÞ·¨É¾³ý". ²é¿´Êý¾Ý¿â,·¢ÏÖ¸ÃÓû§ÓµÓкܶà´æ´¢¹ý³Ì,Ò»¸öÒ»¸ö¸ÄÌ«Âé·³,´ÓÍøÉÏÕÒµ½ÈçÏ·½·¨,Ç¡ºÃ½â¾ö´ËÎÊÌâ:
CR ......
¶ÔÏóÃüÃûµÄÔ¼¶¨£ºÊý¾Ý¿âÃû.ËùÓÐÕßÃû.¶ÔÏóÃû
Ç°Á½Õß¿ÉÊ¡ÂÔ£¬Ä¬ÈÏÖµÊý¾Ý¿âÊǵ±Ç°Êý¾Ý¿â£¬ËùÓÐÕßÊÇdbo
±ðÃû£ºÊý¾Ý¿âÃû³Æ as Êý¾Ý¿â±íÃû Ö÷ÒªÊÇÔö¼ÓselectÓï¾äµÄ¿É¶ÁÐÔ£¬Èç¹ûÒѾΪÊý¾Ý±íÖƶ¨Á˱ðÃû£¬Ôò
ÔÚÏàÓ¦µÄSQLÓï¾äÖУ¬¶Ô¸ÃÊý¾Ý±íµÄËùÓÐÏÔʾÒýÓö¼ÒªÊ¹ÓñðÃû£¬¶ø²»ÄÜʹÓÃÊý¾Ý±íÃû¡£
selectÓï¾äÊÇÊý¾Ý¼ìË÷ÖÐ×îƵ·±µÄ»î¶ ......