是不是JOB 与VBS脚本冲突啊??? 我的MDB文件是用VBS脚本实时进行拷贝的(比如从远程拷贝到本地服务器),我检查发现: .MDB文件在VBS拷贝进行时候回产生一个.LDB文件,如果这时正好在进行插入的操作 insert into **** from MDB....JOB脚本如下: 是不是会产生冲突;倒置我的JOB死掉呢? ... 在JOB中如何判断是否MDB文件在用(正在打开状态,即产生.LDB 文件时)? 有没有象 asp 中 on resume next 之类的语句???? begin traninsert into qjcf35_barcodeprinter.dbo.arrange(id,planno,arrangeid,barrangedate,producedate,cigbrandcode,cigbrand,tradetype,arrangenum,downnum,printnum,applynum,planfinishflag,sendbackflag,confirmflag) select id,planno,arrangeid,barrangedate,producedate,cigbrandcode,cigbrand,tradetype,arrangenum,downnum,printnum,applynum,planfinishflag,sendbackflag,confirmflag from openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', arrange) where barrangedate not in(select barrangedate from qjcf35_barcodeprinter.dbo.arrange)update a set a.printnum=b.printnum, a.applynum=b.applynum, a.planfinishflag=b.planfinishflag, a.sendbackflag=b.sendbackflag, a.confirmflag=b.confirmflag from qjcf35_barcodeprinter.dbo.arrange a,openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', arrange) b where a.barrangedate=b.barrangedate and a.id=b.id and convert(char(10),a.barrangedate,120)>convert(char(10),getdate()-7,120)insert into qjcf35_barcodeprinter.dbo.ciginfo(id,cigbrand,factcode,producedate,tradetype,serialnum,planproducedate,barcodeflag,printstatus,sendbackflag,productinfo) select id,cigbrand,factcode,producedate,tradetype,serialnum,planproducedate,barcodeflag,printstatus,sendbackflag,productinfo from openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', ciginfo) where producedate not in(select producedate from qjcf35_barcodeprinter.dbo.ciginfo)update a set a.producedate=b.producedate, a.printstatus=b.printstatus, a.sendbackflag=b.sendbackflag, a.productinfo=b.productinfo from qjcf35_barcodeprinter.dbo.ciginfo a,openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', ciginfo) b where a.id=b.id and convert(char(10),a.planproducedate,120)>convert(char(10),getdate()-7,120)commit tran
经常搞了 SQLSERVER 无响应~~~~~~~~~~
这边ASP 查询显示啊with(nolock)
是什么意思?
这边ASP 查询显示啊with(nolock)
是什么意思?
-----------
不上鎖其實,查詢是不會鎖的
我的MDB文件是用VBS脚本实时进行拷贝的(比如从远程拷贝到本地服务器),我检查发现:
.MDB文件在VBS拷贝进行时候回产生一个.LDB文件,如果这时正好在进行插入的操作
insert into **** from MDB....JOB脚本如下:
是不是会产生冲突;倒置我的JOB死掉呢?
... 在JOB中如何判断是否MDB文件在用(正在打开状态,即产生.LDB 文件时)?
有没有象 asp 中 on resume next 之类的语句????
begin traninsert into qjcf35_barcodeprinter.dbo.arrange(id,planno,arrangeid,barrangedate,producedate,cigbrandcode,cigbrand,tradetype,arrangenum,downnum,printnum,applynum,planfinishflag,sendbackflag,confirmflag)
select id,planno,arrangeid,barrangedate,producedate,cigbrandcode,cigbrand,tradetype,arrangenum,downnum,printnum,applynum,planfinishflag,sendbackflag,confirmflag
from openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', arrange)
where barrangedate not in(select barrangedate from qjcf35_barcodeprinter.dbo.arrange)update a set
a.printnum=b.printnum,
a.applynum=b.applynum,
a.planfinishflag=b.planfinishflag,
a.sendbackflag=b.sendbackflag,
a.confirmflag=b.confirmflag
from qjcf35_barcodeprinter.dbo.arrange a,openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', arrange) b
where a.barrangedate=b.barrangedate and a.id=b.id
and convert(char(10),a.barrangedate,120)>convert(char(10),getdate()-7,120)insert into qjcf35_barcodeprinter.dbo.ciginfo(id,cigbrand,factcode,producedate,tradetype,serialnum,planproducedate,barcodeflag,printstatus,sendbackflag,productinfo)
select id,cigbrand,factcode,producedate,tradetype,serialnum,planproducedate,barcodeflag,printstatus,sendbackflag,productinfo
from openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', ciginfo)
where producedate not in(select producedate from qjcf35_barcodeprinter.dbo.ciginfo)update a set
a.producedate=b.producedate,
a.printstatus=b.printstatus,
a.sendbackflag=b.sendbackflag,
a.productinfo=b.productinfo
from qjcf35_barcodeprinter.dbo.ciginfo a,openrowset('Microsoft.Jet.OLEDB.4.0', 'D:\web\barcodeprinter\backup\barcodeprinter35.mdb';'admin';'', ciginfo) b
where a.id=b.id
and convert(char(10),a.planproducedate,120)>convert(char(10),getdate()-7,120)commit tran