直接写select语句就行了: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[成型预备_NCPPODTL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[成型预备_NCPPODTL] select * into 成型预备_NCPPODTL from openrowset ('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=z:\user\common\prod', 'SELECT * FROM NCPPODTL WHERE ASC(SUBSTR(PPO_NO,1,1))=67 AND ASC(SUBSTR(PPO_NO,2,1))=80 AND asc(SUBSTR(PPO_NO,7,1))>=51') select '成型预备_NCPPODTL' 表名,getdate() 建表时间 go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[成型预备_NCPPODTL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[成型预备_NCPPODTL]
select * into 成型预备_NCPPODTL
from openrowset
('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=z:\user\common\prod',
'SELECT * FROM NCPPODTL WHERE ASC(SUBSTR(PPO_NO,1,1))=67 AND ASC(SUBSTR(PPO_NO,2,1))=80 AND asc(SUBSTR(PPO_NO,7,1))>=51')
select '成型预备_NCPPODTL' 表名,getdate() 建表时间
go
然后另建一个存储过程B,B用来调用A并同时记录调用时间到上面说的表
应用程序调用存储过程B就是了