Ò»ÌõSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

SELECT SR_ID from Employee
²é³öÀ´µÄÓÐ NULL £¬ÓÐÊý×Ö¡£

SELECT CASE WHEN SR_ID IS NULL THEN '·ñ' ELSE 'ÊÇ' END from Employee

²é³öÀ´µÄÊý×Ö±ä³É 'ÊÇ' ÁË£¬µ«NULL »¹ÊÇNULL.

ΪʲôNULL û±ä³É ·ñ£¿

---

²»»á°É?

---

ÒýÓÃ

SELECT SR_ID from Employee
²é³öÀ´µÄÓÐ NULL £¬ÓÐÊý×Ö¡£

SELECT CASE WHEN SR_ID IS NULL THEN '·ñ' ELSE 'ÊÇ' END from Employee

²é³öÀ´µÄÊý×Ö±ä³É 'ÊÇ' ÁË£¬µ«NULL »¹ÊÇNULL.

ΪʲôNULL û±ä³É ·ñ£¿

ÄãÌùµãÊý¾Ý¿´¿´,Èç¹ûÕæÊÇÕâÑù,ÄǾÍÉñÆæÁË.

---

ÒýÓÃ

SELECT SR_ID from Employee
²é³öÀ´µÄÓÐ NULL £¬ÓÐÊý×Ö¡£

SELECT CASE WHEN SR_ID IS NULL THEN '·ñ' ELSE 'ÊÇ' END from Employee

²é³öÀ´µÄÊý×Ö±ä³É 'ÊÇ' ÁË£¬µ«NULL »¹ÊÇNULL.

ΪʲôNULL û±ä³É ·ñ£¿

Èç¹ûÕâ¾ä£¬Ó¦¸Ã²»»á£¬³ý·ÇÄÚÈÝÊÇ×Ö·ûÐ͵Ä'NULL'

---

isnull(SR_ID ,'·ñ')ÄØ?

---

SQL code:
create table tb(id int)
insert into tb values(1)
insert into tb values(1)
insert into tb values(null)
go

select case when id is null then 'ÎÞ' else 'ÊÇ' end from tb

drop table tb

/*

----
ÊÇ
ÊÇ
ÎÞ

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©
*/

---

SQL code:
create table tb(id in