SQLÓï¾ä²éѯÊÇ·ñΪ¿Õ =null¼°null
a b c d
980515 ¾«頂Æó業ÓÐÏÞ¹«Ë¾ 簡¼ÒºÀ NULL
980514 È«ÐÀľ業ÓÐÏÞ¹«Ë¾ NULL 123
980514 Ѹ億¿Æ¼¼¹É·ÝÓÐÏÞ¹«Ë¾ 簡·ê¿£ NULL
980515 聖Ô½國際Æó業ÓÐÏÞ¹«Ë¾ NULL 111
±í½á¹¹ÈçÉÏËùʾ£¬Òª²éѯCÁÐΪ¿ÕµÄ¼Ç¼µÄ£Ó£Ñ£ÌÓï¾ä²»ÊÇselect * from table where c=null; »òÕß select * from table where c=’’; ¶øÓ¦µ±ÊÇ select * from table where c is null; Ïà·´µØÒª²éѯ²»Îª¿ÕµÄÔòÓ¦µ±ÊÇ select * from talbe where c<>’’; »òÕß select * from table where c is not null; ×¢Ò⣺²»ÊÇnot is nullŶ¡£
Ïà¹ØÎĵµ£º
(1) Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò
(
Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ
)
£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àí
from
×Ó¾ä
ÖеıíÃû£¬
from
×Ó¾äÖÐдÔÚ×îºóµÄ±í
(
»ù´¡±í
driving table)
½«±»×îÏÈ´¦Àí£¬ÔÚ
from
×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ
,
Äã±ØÐëÑ¡
Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í ......
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËÆµÄ¹¦ÄÜ¡£
Óï·¨
ʹÓà CAST£º
CAST ( expression AS data_type )
ʹÓà CONVERT£º
CONVERT (data_type[(length)], expression [, style])
²ÎÊý
expression
ÊÇÈκÎÓÐЧµÄ Microsoft® SQL Server™ ±í´ïʽ¡£Óйظü¶àÐÅÏ¢£¬Çë² ......
Ö¢×´£º
SQL SERVER2005ÀïÃæ£¬Æô¶¯SQL´úÀí·þÎñ£¬Æô¶¯Õý³££¬µ«ÊÇÔÚsql server ´úÀí»¹ÊÇÏÔʾÒѽûÓôúÀí xp
ÔÚManagement StudioÖÐн¨Î¬»¤¼Æ»®Ê±£¬ÌáʾÒÔÏ´íÎóÐÅÏ¢£º
“´úÀíXP”×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö±»¹Ø±Õ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔʹÓÃsp_configureÀ´ÆôÓÓ´úÀíXP”¡£ÓÐ¹ØÆôÓÓ´úÀíXP ......
ÒÔÏÂ˵Ã÷¾ùÕë¶ÔÆóÒµ°æ»òÕß¿ª·¢°æ£»
1.¿ªÆôsql server ʵÀýµÄÔ¶³ÌÁ¬½Ó£»
“¿ªÊ¼”-->“³ÌÐò”-->“Microsoft SQL Server 2005”-->“ÅäÖù¤¾ß”-->“SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”-->“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”--> ......
SQL Server ÒÑ·â鎖Ôª¼þ 'xp_cmdshell' µÄ ³ÌÐò 'sys.xp_cmdshell'
Ö®´æÈ¡£¬Òò為´ËÔª¼þÒÑ經ÓÉ´ËËÅ·þÆ÷µÄ°²È«ÐÔ組態關閉¡£Ïµ統¹ÜÀí員¿ÉÒÔʹÓà sp_configure 來啟Óà 'xp_cmdshell'
µÄʹÓá£ÈçÐèÓÐ關啟Óà 'xp_cmdshell' µÄ詳಄ ......