Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÒÔÍâµÄÇé¿ö



Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ