create proc insert_BL_Procject@pf varchar(1000)as declare @Program_ID intdeclare @sql varchar(8000) select @sql = '''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@pf+''',''select 项目编码 as BL_ProjectNum,项目名称 as BL_ProjectName,项目特征 as BL_ProjectTrait, 计量单位 as BL_UnitID,工程数量 as BL_quantity,单价 as BL_UnitPrice,合价 as BL_TotalPrice from [sheet1$]''' select @sql set @Program_ID=(select top 1 Program_ID from BL_BudgetListing order by Program_ID desc)+1exec('insert into BL_BudgetListing select BL_ProjectNum, BL_ProjectName, BL_ProjectTrait, BL_UnitID, BL_quantity, BL_UnitPrice, BL_TotalPrice,' +@Program_ID+' from openrowset('+@sql')' --这么写试试吧
try create proc insert_BL_Procject@pf varchar(1000)as declare @Program_ID intdeclare @Tsql varchar(8000)declare @sql varchar(8000) select @sql = '''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@pf+''',''select 项目编码 as BL_ProjectNum,项目名称 as BL_ProjectName,项目特征 as BL_ProjectTrait, 计量单位 as BL_UnitID,工程数量 as BL_quantity,单价 as BL_UnitPrice,合价 as BL_TotalPrice from [sheet1$]''' select @sql set @Program_ID=(select top 1 Program_ID from BL_BudgetListing order by Program_ID desc)+1exec('insert into BL_BudgetListing select BL_ProjectNum, BL_ProjectName, BL_ProjectTrait, BL_UnitID, BL_quantity, BL_UnitPrice, BL_TotalPrice,' + @Program_ID +' from openrowset('+@sql +')')
declare @Program_ID intdeclare @sql varchar(8000)
select @sql = '''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@pf+''',''select 项目编码 as BL_ProjectNum,项目名称 as BL_ProjectName,项目特征 as BL_ProjectTrait,
计量单位 as BL_UnitID,工程数量 as BL_quantity,单价 as BL_UnitPrice,合价 as BL_TotalPrice from [sheet1$]'''
select @sql
set @Program_ID=(select top 1 Program_ID from BL_BudgetListing order by Program_ID desc)+1exec('insert into BL_BudgetListing
select
BL_ProjectNum,
BL_ProjectName,
BL_ProjectTrait,
BL_UnitID,
BL_quantity,
BL_UnitPrice,
BL_TotalPrice,'
+@Program_ID+'
from
openrowset('+@sql')'
--这么写试试吧
第 27 行: ')' 附近有语法错误。
declare @Program_ID intdeclare @Tsql varchar(8000)declare @sql varchar(8000)
select @sql = '''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@pf+''',''select 项目编码 as BL_ProjectNum,项目名称 as BL_ProjectName,项目特征 as BL_ProjectTrait,
计量单位 as BL_UnitID,工程数量 as BL_quantity,单价 as BL_UnitPrice,合价 as BL_TotalPrice from [sheet1$]'''
select @sql
set @Program_ID=(select top 1 Program_ID from BL_BudgetListing order by Program_ID desc)+1exec('insert into BL_BudgetListing
select
BL_ProjectNum,
BL_ProjectName,
BL_ProjectTrait,
BL_UnitID,
BL_quantity,
BL_UnitPrice,
BL_TotalPrice,'
+ @Program_ID +'
from
openrowset('+@sql +')')