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

SQL Server 2005 ÎÞ·¨µÇ½

ÎÊÌâÃèÊö

    ÓÐÁ½Ì¨·þÎñÆ÷ DB1£¨10.10.10.1£©  DB2£¨10¡¢10¡¢10¡¢2£©    ÕâÁ½Ì¨»úÆ÷×öµÄ  Ⱥ¼¯  ÐéÄâIP £¨10¡¢10¡¢10¡¢11£©

¹úÇì·Å¼Ù»ØÀ´·¢ÏÖ ·þÎñÆ÷ ÎÞ·¨µÇ½£¬±¾»úµÇ½£¬Ô¶³ÌµÇ¼¶¼²»¿ÉÒÔ¡£²¢ÇÒ SQLSERVER ·þÎñ¾­³£Í£µô¡£

ÏëÅäÖÃÍâΧӦÓóÌÐò£¬½á¹û  µ¯³ö  Ìáʾ  ¡°ÄúÎÞ·¨Í¨¹ýÁ¬½Óµ½¼ÆËã»úÃû³ÆÀ´ÅäÖÃȺ¼¯·þÎñµÄÍâΧӦÓã¬ÇëÁ¬½Óµ½ÐéÄâ·þÎñÆ÷

À´ÅäÖÃȺ¼¯·þÎñ¡£¡±


ÏÈлл¸÷λ¸ßÊÖ½â´ðÁË£¬


End_rbody_60301808//-->
¸Ã»Ø¸´ÓÚ2009-10-11 09:02:55±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








kimma
(ÐÇ¿Õ)

µÈ¡¡¼¶£º



#2Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-10-10 09:31:57


Â¥ÉϵÄÅ£ÈË  2009-10-10 05:20:50  »ØÌû£¡£¡£¡£¡£¡

Å£ 

²»Ì«Çå³þ



ѧϰÁË£¬²»ÖªµÀ¡£Å£ÈËѽ

ÖØÆôһϷþÎñÊÔÊÔ¡£

ÖØÆô»úÆ÷¡­¡­

ÎÒºÃÏëÖ»ÊÇʲôÊǼ¯Èº£¿ºÃÉñÆæµÄ¶«Î÷

°¦£¬²éÁËÁ½ÌìҲû²é³öÀ´ÎÊÌ⣬û°ì·¨£¬ÖØÐÂװϵͳ  ÖØÐÂ×öµÄ Ⱥ¼¯¡£

É¢·Ö°É£¬Ð»Ð»¸÷λ»ØÌûÁË 


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ