Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇósqlÎÄ

ÇóA != 1 and B != 2 ÒÔÍâµÄ¼Ç¼
a!=1 and b!=2 ÒÔÍ⣿

ÄÇÆñ²»ÊÇa=1»òÕßb=2µÄÕâÖÖÇé¿öô

select * from table where a = 1 or b = 2

Èç¹ûÊÇA != 1 and B != 2µÄ»°
select * from table where a <> 1 and b <> 2

where not(A!=1 and B!=2)

ÒýÓÃ
Èç¹ûÊÇA != 1 and B != 2µÄ»°
select * from table where a <> 1 and b <> 2


ÕâÑù×ÓOK!

¸÷λ£º
  Çë¿´ºÃÁË£¬ÊÇA £¡= 1 ͬʱ B!= 2 ÒÔÍâµÄÇé¿ö

A £¡= 1 and B!= 2
ËüµÄ·´Òå¾ÍÊÇ£º
A = 1 or B = 2

ÒýÓÃ
¸÷λ£º
  Çë¿´ºÃÁË£¬ÊÇA £¡= 1 ͬʱ B!= 2 ÒÔÍâµÄÇé¿ö

ÄãµÄÃèÊö´æÔÚÆçÒå
Èç¹ûÊÇ¡°ÇóA != 1¡± and¡° B != 2 ÒÔÍâµÄ¼Ç¼¡±
Ìõ¼þ¾Íд
where a!=1 and not(b!=2)
µ±È»ÄãÒ²¿ÉÒÔд³Éwhere a!=1 and b=2
Äã¸ù¾ÝÐèÒªÐÞ¸ÄÏÂ

A £¡= 1 ͬʱ B!= 2 ÒÔÍâµÄÇé¿ö

Çé¿ö1£º
£¨A £¡= 1 ͬʱ B!= 2£©ÒÔÍâµÄÇé¿ö£¬Ôò
a = 1 or b = 2 or a is null or b is null;

Çé¿ö2£º
A £¡= 1 ͬʱ £¨B!= 2ÒÔÍ⣩µÄÇé¿ö£¬Ôò
a != 1 and (b = 2 or b is null);

ÀëÉ¢ÊýѧÊéÉÏÓС£

ÒýÓÃ
¸÷λ£º
  Çë¿´ºÃÁË£¬ÊÇA £¡= 1 ͬʱ B!= 2 ÒÔÍâµÄÇé¿ö



Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sql ´æ´¢¹ý³ÌÎÊÌâ

SQL code:
declare @t varchar(5000)
set @t=''
select @t=@t+',[È¡Ïû·ÖÎö-'+quXiaoFenXi+']=sum(case when [quXiaoFenXi]='+quotename([quXiaoFenXi],'''')+' then shangPinZongShu else 0 end)'
from tb_gyyD ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ