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

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£

select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ


select * from
  ±íA ,±íB ,±íC , ±íD, ±íE
Where ÆäËûÌõ¼þ and ±íA.id || ' ' =±íB.id


Èç¹û¸÷ÖÖÌõ¼þÊÇÒ»ÖµĻ°£¬ÄÚÁ¬½ÓÊÇ×î¿ìµÄ¡£¼´µÚ¶þÖÖ·½·¨

µÚ¶þÖÖÊÇËûÃÇÌṩҪ¸Ä½øµÄ·½Ê½£¬Êý¾ÝÌ«¶à¡£
Ҫд·ÖÎöÔ­Òò£¬¾ÍÊÇҪд³öΪʲô¸Ä½øÖ®ºóËÙ¶È»á´ó·ù¶ÈÌá¸ß¡£

ÀíÂÛÉϽ²£¬Á¬½ÓÖÐÄÚÁ¬½ÓÊÇ×î¿ìµÄ£¬ÒòΪֻÓзûºÏÌõ¼þµÄ¼Ç¼²Å»áɸѡ³öÀ´

from 
  ( "A" 
  LEFT OUTER JOIN "B" ON ( "A"."id" = "B"."id" ) )
  LEFT OUTER JOIN "C" ON ( "A"."id" = "C"."id" ), "D"
 WHERE
"A"."Äê·Ý" = ?
  AND "A"."Ãû³Æ" = "D"."Ãû³Æ"
  AND "A"."ºÅÂë1" = "D"."ºÅÂë1"
  AND "A"."ºÅÂë2" = "D"."ºÅÂë2"
  AND "A"."id" = "D"."id"
..............................................
from "A" INNER JOIN "D" ON ( "A"."Ãû³Æ" = "EDA"."Ãû³Æ"
 AND "A"."ºÅÂë1" = &q


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

sql ʱ¼äÎÊÌâ

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

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

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

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

Çë½Ì¸÷λ´ó¸çÒ»¸öSqlÎÊÌ⣬Äĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¿

СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´


°à¼¶±í                  ½Ìʦ±í

°à¼¶ID    & ......

Çó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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ