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

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

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......

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

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

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

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

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

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

sql ÎÊÌâ

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

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