CREATE PROCEDURE hotel_sjdl AS
--加上这两句
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GOinsert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=E:\HOTEL',
'select * from 客户表.dbf')
select rtrim(convert(char(10),zh))+rtrim(convert(char(3),xh))as bh,isnull(xm,''),py='',isnull(right(rtrim(xb),1),''),mz='',
isnull(convert(char(10),csrq,120),getdate()),isnull(csd,''),isnull(fh,''),ch='',isnull(zjlx,''),isnull(zjhm,''),isnull(zjyxq,''),isnull(dw,''),
xzqh='',isnull(xxdz,''),zsyy='',isnull(lc,''),isnull(convert(char(5),yzts),0),isnull(ddsj,getdate()),isnull(lksj,getdate()),isnull(sryg,''),isnull(tfyg,''),xyklx='',xykhm=''
from t_q_fkr where ddsj between '2003-3-1' and '2004-3-10' and krly='1内宾' and zt<>'删除'
--加上这两句
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GOinsert into openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=E:\HOTEL',
'select * from 客户表.dbf')
select rtrim(convert(char(10),zh))+rtrim(convert(char(3),xh))as bh,isnull(xm,''),py='',isnull(right(rtrim(xb),1),''),mz='',
isnull(convert(char(10),csrq,120),getdate()),isnull(csd,''),isnull(fh,''),ch='',isnull(zjlx,''),isnull(zjhm,''),isnull(zjyxq,''),isnull(dw,''),
xzqh='',isnull(xxdz,''),zsyy='',isnull(lc,''),isnull(convert(char(5),yzts),0),isnull(ddsj,getdate()),isnull(lksj,getdate()),isnull(sryg,''),isnull(tfyg,''),xyklx='',xykhm=''
from t_q_fkr where ddsj between '2003-3-1' and '2004-3-10' and krly='1内宾' and zt<>'删除'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货