sql ²éѯ
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд. Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ ÔÂÈÕ×éºÏµÄÐÎʽÈçÏ 10-17/04-20 ÔÂ-ÈÕ/ÔÂ-ÈÕ Çó½Ì¸÷λ´óÏÀ
來點數據°É~~ ÓÃÏÈÅÐ斷λ數ÔÙÓÃsubstringÈ¡ 15轉換18參ÕÕ select * from view_MemberInfo where ( case when len(f_CardID) = 15 then substring(f_CardID,9,4) else substring(f_CardID,11,4) end) between '1017' and '0420' ÕâÑùд¶ÔôÒýÓà ÓÃÏÈÅÐ斷λ數ÔÙÓÃsubstringÈ¡ 15轉換18參ÕÕ Ö§³Ö {{
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ? dts¹¤¾ß µ¼Èëµ¼³ö¹¤¾ß. DD ¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»ÁËµÄ Ö±½ÓÐ ......
ǰ¼¸Ìì¹«Ë¾ÃæÊÔ£¬¼ûµ½Ò»Ìâ,Çë¸ßÊÖ°ïÎÒ½â´ð£¬Ð»Ð»£¡ ÄÚÈÝtable: id name parentid 1 aaa null 14 bbb 1
......
PBÖпª·¢µÄ¡£ DateTime startTime=DateTime(em_1.Text) DateTime endTime=DateTime(em_2.Text) string sql sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......