²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?
±íA
Sup_code st_sup_code buy_code buy_code1
1001 400 a a
1002 401 a b
1003 402 b b
1004 403 b b
1005 404 c c
1006 405 c a
ÎÒÏëÈ¡buy_code £¬buy_code1 Á½¸öÁÐÖв»Öظ´µÄÖµ
½á¹ûΪ
1001 400 a
1002 401 a
1002 401 b
1003 402 b
1004&
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......
ÎÒÍøÉÏÉêÇëÁËÒ»¸öÄÜÊÔÓÃsqlµÄÍøÖ·£¬°ÑÊý¾Ý¿â±¸·Ý³É1.bak£¬È»ºóÉÏ´«µ½ËûµÄ¿Õ¼ä¸²¸Ç£¬¾ÍÐУ¬È»ºó¸ÄÁËÏÂ.netµÄÁ¬½ÓµØÖ· µ«×ÜÊDz»Äܳɹ¦Á¬½Ó¡£
ºóÀ´ÎÒÄǸöÉêÇë¿Õ¼äµÄ±»¹ØÁË£¬ÏÖÔÚÓÐÔÝÍ£¿Õ¼äµÄÉêÇë
ËùÒÔÇëÎÊÏ ......