SQLÄܽøÐжþ½øÖƵÄɸѡÂ𣿠- MS-SQL Server / »ù´¡Àà

ÎÒÓÐÒ»¸ö×Ö¶ÎÊÇ varchar(1) ÀàÐÍ£¬¶þ½øÖƱíʾҲ¾ÍÊÇ8λµÄ ¡®0000 0000¡¯
±ÈÈçÕâ¸öʱºòÎÒÐèҪɸѡ³öÕâ¸ö×Ö¶ÎΪËùÓÐµÄ ¡®0000 0100¡¯µÄÐУ¬ÇëÎÊSQLÄÜʵÏÖÕâÑùµÄ¡°Î»¡±µÄɸѡÂð£¿
лл~~~

---

ÓÐλ²Ù×ݺ¯ÊýÂ𣿲»ÐоÍ×Ô¼ºÐ´°É£¡

---

SELECT 4&4

--0100--4
--0100--4


/*
   
----------- 
4

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

---

¿ÉÒÔͨ¹ýCASTת»»²éѯ

---

ÒýÓÃ

SELECT 4&4

--0100--4
--0100--4


/*

-----------
4

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

²»ºÃÒâ˼£¬ÎÒû¿´¶®ÄãµÄÒâ˼¡£
ÎÒÏÖÔÚÊÇ select * where ij×ֶΠ<> '0000 0100' from table
ÇëÎÊÒªÈçºÎдÄØ£¿

---

¸ø³öÊý¾äºÍÄãÒªµÄ½á¹û

---

ÒýÓÃ

ÎÒÓÐÒ»¸ö×Ö¶ÎÊÇ varchar(1) ÀàÐÍ£¬¶þ½øÖƱíʾҲ¾ÍÊÇ8λµÄ ¡®0000 0000¡¯
±ÈÈçÕâ¸öʱºòÎÒÐèҪɸѡ³öÕâ¸ö×Ö¶ÎΪËùÓÐµÄ ¡®0000 0100¡¯µÄÐУ¬ÇëÎÊSQLÄÜʵÏÖÕâÑùµÄ¡°Î»¡±µÄɸѡÂð£¿
лл~~~

²»´ó¶®ÄãµÄÒâ˼
varchar(1)Ôõô¿ÉÒÔ×°8λÄØ
ÒªÊÇÊý¾ÝÖ»ÓÐÒ»¸ö×Ö·û´®
Ö±½Ó
select * from tb where col = '1'

---

ÒýÓÃ

¸ø³öÊý¾äºÍÄãÒªµÄ½á¹û

SQL code:

select * from table A
where ij×ֶΠnot in( '0000 0100','0000 0