SQL ServerÖеÄNullÖµ½âÎö
NULL
ÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪ
NULL
£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬
NULL
²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇ
NULL
µÄÓÉÀ´¡¢Ò²ÊÇ
NULL
µÄ»ù´¡£¬ËùÓкÍ
NULL
Ïà¹ØµÄ²Ù×÷µÄ½á¹û¶¼¿ÉÒÔ´Ó
NULL
µÄ¸ÅÄîÍƵ¼³öÀ´¡£
ÅжÏÒ»¸ö×Ö¶ÎÊÇ·ñΪ
NULL
£¬
Ó¦¸ÃÓÃ
IS
NULL
»ò
IS NOT NULL
£¬¶ø²»ÄÜÓÃ
‘=’
¡£¶Ô
NULL
µÄÅжÏÖ»Äܶ¨ÐÔ£¬¼ÈÊDz»ÊÇ
NULL
£¨
IS NULL/IS NOT NULL
£©£¬¶ø²»Äܶ¨Öµ¡£¼òµ¥µÄ˵£¬ÓÉÓÚ
NULL
´æÔÚ×ÅÎÞÊýµÄ¿ÉÄÜ£¬Òò´ËÁ½¸ö
NULL
²»ÊÇÏàµÈµÄ¹Øϵ£¬Í¬ÑùÒ²²»ÄÜ˵Á½¸ö
NULL
¾Í²»ÏàµÈ£¬»òÕ߱ȽÏÁ½¸ö
NULL
µÄ´óС£¬ÕâЩ²Ù×÷¶¼ÊÇûÓÐÒâÒ壬µÃ²»µ½Ò»¸öÈ·ÇеĴ𰸵ġ£Òò´Ë£¬¶Ô
NULL
µÄ
=
¡¢
!=
¡¢
>
¡¢
<
¡¢
>=
¡¢
<=
µÈ²Ù×÷µÄ½á¹û
¶¼ÊÇδ֪µÄ£¬Ò²¾ÍËã˵£¬ÕâЩ²Ù×÷µÄ½á¹ûÈÔÈ»ÊÇ
NULL
¡£
ͬÀí£¬¶Ô
NULL
½øÐÐ
+
¡¢
-
¡¢
*
¡¢
/
µÈ²Ù×÷µÄ½á¹ûÒ²ÊÇδ֪µÄ£¬ËùÒÔÒ²ÊÇ
NULL
¡£
ËùÒÔ£¬ºÜ¶àʱºò»áÕâÑù×ܽá
NULL
£¬³ýÁË
IS NULL
¡¢
IS NOT NULL
ÒÔÍ⣬¶Ô
NULL
µÄÈκβÙ×÷µÄ½á¹û»¹ÊÇ
NULL
¡£
ÏÂÃæÁоÙÁË
SQL
Server
Öд¦Àí
null
ֵʱÈÝÒ׺öÂԵļ¸¸öµØ·½¡£
ÔÚÔĶÁÏÂÎÄ֮ǰ£¬ÇëÏÈ´´½¨Ê¾Àý±í£¬
Script
ÈçÏ£º
create
table
dbo.
cassaba_null
(
column1 nvarchar
(
50)
not
null,
column2 nvarchar
(
50)
null
)
go
insert
into
dbo.
cassaba_null values
(
'1'
,
null)
insert
into
dbo.
cassaba_null values
(
'2'
,
'string'
)
insert
into
dbo.
cassaba_null values
(
'3'
,
''
)
go
1.
ʹÓÃ
=null
/ <>null
ß×£¬¿ªÆª²»¾Í˵²»ÄÜʹÓÃ
=null / <> null
À´ÅжÏ
null
ÖµÂð£¿Êǵģ¬Ä¬È
Ïà¹ØÎĵµ£º
Èç¹ûÎÒÃǵÄSQL ServerÒª±£Ö¤¸ß¿ÉÓÃÐÔ£¬ÄÇô¿ÉÒÔ²ÉÓùÊÕÏתÒÆȺ¼¯¡£×î¼òµ¥µÄ¹ÊÕÏתÒÆȺ¼¯ÊÇÁ½Ì¨·þÎñÆ÷£¬Ò»Ì¨×ö»î¶¯µÄ·þÎñÆ÷£¬Áíһ̨×ö±¸Ó÷þÎñÆ÷£¬Õâ¾ÍÊÇAPģʽµÄCluster¡£ÁíÍâÒ»¸öģʽ¾ÍÊÇAAģʽ£¬Ò²¾ÍÊÇÁ½Ì¨·þÎñÆ÷¶¼ÊÇÔËÐÐSQL ServerʵÀý¡£
SQL Server²»ÏñOracleÒ»ÑùÓÐRAC£¬ËùÒÔ²»¿ÉÄÜ˵Á½Ì¨·þÎñÆ÷ͬʱÔËÐÐͬһ¸öʵÀý£¬Ïë ......
SQLº¯ÊýÖ®ËÄÉáÎåÈ루ת×Ôhttp://ln1058.javaeye.com/blog/191502£©
ÎÊÌâ1£º
SELECT CAST('123.456' as decimal) ½«»áµÃµ½ 123£¨Ð¡ÊýµãºóÃæµÄ½«»á±»Ê¡ÂÔµô£©¡£
Èç¹ûÏ£ÍûµÃµ½Ð¡ÊýµãºóÃæµÄÁ½Î»¡£
ÔòÐèÒª°ÑÉÏÃæµÄ¸ÄΪ
SELECT CAST('123.456' as decimal(38, 2)) ===>123.46
×Ô¶¯ËÄÉáÎåÈëÁË£ ......
¹Ì¶¨ÈÕÆÚ¼õÒ»¸öÔ£¨ÈÕ¡¢Ä꣩
dateadd(±í´ïʽ1£¬±í´ïʽ2£¬±í´ïʽ3£©
±í´ïʽ1ΪMM»òYY»òDD
±í´ïʽ2Ϊ1
±í´ïʽ3ΪҪ¼õµÄÈÕÆÚ Ò»¸öÔµĵÚÒ»Ìì µÚÒ»¸öÀý×Ó£¬ÎÒ½«¸æËßÄãÈçºÎ´Óµ±Ç°ÈÕÆÚÈ¥Õâ¸öÔµÄ×îºóÒ»Ìì¡£Çë×¢Ò⣺Õâ¸öÀý×ÓÒÔ¼°ÕâƪÎÄÕÂÖеÄÆäËûÀý×Ó¶¼½«Ö»Ê¹ÓÃDATEDIFFºÍDATEADDº¯ÊýÀ´¼ÆËãÎÒÃÇÏëÒªµÄÈÕ ......
ÿÌ죬ÿÖܵÄÖ´ÐÐ
±ÈÈç¿ÉÒÔ¿ØÖÆÿÌìÖ»ÄÜͶƱÈý´Î¡£
ÿÖÜҪͳ¼ÆÒ»ÏÂͶƱÊý¡£
1¡¢Äã±ØÐ뿪Æô´úÀí·þÎñsql server agent
2¡¢ÔÚÆóÒµ¹ÜÀíÆ÷À´ò¿ª“¹ÜÀí—>sqlserver´úÀí—>×÷Òµ”£¬ÐÂÔö×÷Òµ£¬Ð½¨“²½Ö蔣¬ÔÚ²½ÖèÀïÌîÈëÄãҪתÒƵÄSQLÓï¾äµ½“ÃüÁòÀȻºóн¨“µ ......
Ê×Ïȸø³öÁ½ÕŲâÊÔ±í
a(aid int, adata varchar(20)) b(bid int, bdata varchar(20))
1.join Óë inner join
Ö´ÐÐÈçÏÂÓï¾ä£º
select * from a join b on a.aid = b.bid;
ÎÒÃÇ»áµÃµ½ÈçϵĽá¹û£º
AID ADAT ......