SQL语句
time1=format(now,"hh:mm:ss")
fromtime,totime
sCmd = "Update Tables Set SiteStatus=1 Where TableName In (Select TableName from tableBook Where BookDate='" & Format(Now, "yyyy-mm-dd") & "' And DatePart=" & tmpDatePart & " and fromTime < " & time1 & " and " & time1 & " < ToTime ) And SiteStatus <2"
error: fromTime < " & time1 & " and " & time1 & " < ToTime
time1=format(now,"hh:mm:ss")
fromtime=Format(DTPicker1.Value, "hh:mm:ss")
Totime=Format(DTPicker2.Value, "hh:mm:ss")
格式是一样的
修改一下
sCmd = "Update Tables Set SiteStatus=1 Where TableName In (Select TableName from tableBook Where BookDate='" & Format(Now, "yyyy-mm-dd") & "' And DatePart=" & tmpDatePart & " and fromTime < #" & time1 & "# and ToTime > #" & time1 & "# ) And SiteStatus <2"
来晚了,顶一下
也可以这样写
sCmd = "Update Tables Set SiteStatus=1 Where TableName In (Select TableName from tableBook Where BookDate='" & Format(Now, "yyyy-mm-dd") & "' And DatePart=" & tmpDatePart & " and #" & time1 &a
相关问答:
小弟是个新手 现在有个问题一直不能解决
例如
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
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 ......
执行的顺序:
1)文件浏览框(选择文件使用)
选择好文件后
点击一个导入按钮的时候 ,把上面上传框里的csv文件以一个ID为文件名,上传到**/**文件夹下
2)读取这个文件夹下的csv的文件,转换成sql
3 ......
sql可以有两个以上的触发器吗??我指的是for触发器,那其他的呢??
什么意思?
可以的
10个都没问题
可是我写了两个for insert 触发器,造成进程阻塞了呢?怎么办呢?请高人指点
......
请问:
1,如何将一张dbf表导入到sql server2000中的一张表。使用DTS该怎样实现?
2,使用网上代码:
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......