易截截图软件、单文件、免安装、纯绿色、仅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+ASP

....接到一个小程序..工作原来大概是这样的...前台是WEB服务器.架构就是ASP+SQL..前台由ASP向SQL添加服务类别(表单).然后又后台程序读取表单..要实时读取..然后显示在服务器上面..从理论上面能行通不?如果可以..后台 ......

sql server 存储过程循环赋值的问题

小弟是个新手 现在有个问题一直不能解决
例如
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

关于group by的sql语句?

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

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号