create proc zhao @a varchar(255) as begindeclare @TMP_COM_BASEARG varchar(255) if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TMP_COM_BASEARG]Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source="'+@a+'";User ID=;Password=')...COM_BASEARGend 这样的话,显示,+号附近有错误!
create proc zhao @a varchar(255) as begin
declare @TMP_COM_BASEARG varchar(255) if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TMP_COM_BASEARG] declare @drv varchar(8000) set @drv='Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE (''Microsoft.Jet.OLEDB.4.0'', ''Data Source="'+@a+'";User ID=;Password='')...COM_BASEARG' exec (@drv)end
as
begindeclare @TMP_COM_BASEARG varchar(255)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMP_COM_BASEARG]Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0','Data Source="'+@a+'";User ID=;Password=')...COM_BASEARGend
这样的话,显示,+号附近有错误!
as
begin
declare @TMP_COM_BASEARG varchar(255)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMP_COM_BASEARG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMP_COM_BASEARG]
declare @drv varchar(8000)
set @drv='Select * INTO TMP_COM_BASEARG FROM OPENDATASOURCE (''Microsoft.Jet.OLEDB.4.0'',
''Data Source="'+@a+'";User ID=;Password='')...COM_BASEARG' exec (@drv)end