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 table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
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 ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......