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

SQL²é詢語¾äSelect

SQL²é詢語¾äSelect
ÒªÇóÈçÏ£º£¨inputdatetime or Outputdatetime£© and Name
´ú碼ÈçÏ£º
sql = "select *from Info where inputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "#  or Outputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "#  and Name='" & ExportName.Text & " '"
Ŀǰ無·¨現實ÒªÇó£»
http://download.csdn.net/source/1644211

ÒýÓÃ
http://download.csdn.net/source/1644211

ÏÂ載²»ÁË£¬¿ÉÄÜÊÇ積·Ö²»夠°É£»
ÄÜ傳給ÎÒ嗎£¿TKS!
mail£ºgolden8510@163.com


ÒýÓÃ
ÒýÓÃÂ¥Ö÷ golden8510 µÄ»Ø¸´:
SQL²é詢語¾äSelect
ÒªÇóÈçÏ£º£¨inputdatetime or Outputdatetime£© and Name
´ú碼ÈçÏ£º
sql = "select *from Info whereinputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "# orOutputdatetime between #" & StartDate.Value + StartTime.Value & "# and #" & StopDate.Value + StopTime.Value & "# andName='" & ExportName.Text & " '"
Ŀǰġ


Ïà¹ØÎÊ´ð£º

sql ÎÊÌâ

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......

²»Ã÷°×µÄSQL×¢ÈëÎÊÌâ

ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò

ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿
Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿
¿ÉÄÜÊÇwhere ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ