set @sqlstr='insert into OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Excel 8.0;HDR=Yes;DATABASE='+@path+''',[sheet1$]) select Darpt_Name,Num_Code, Name1,sex from BasicInfo_Table where Name1 = '''+@namestring1+''''。这边貌似要这样
ALTER PROCEDURE [dbo].[NameDBToExcel] @path nvarchar(200), @namestring1 nvarchar(50) AS BEGIN declare @sqlstr nvarchar(2000) set @sqlstr='insert into OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Excel 8.0;HDR=Yes;DATABASE='+@path+''',[sheet1$]) select Darpt_Name,Num_Code, Name1,sex from BasicInfo_Table where Name1 = '''+@namestring1+'''' 字符串的变量需要+'',在动态语句里用'转义一下。
Name1,sex from BasicInfo_Table where Name1 = '''+@namestring1+''''。这边貌似要这样
@path nvarchar(200),
@namestring1 nvarchar(50)
AS
BEGIN
declare @sqlstr nvarchar(2000)
set @sqlstr='insert into OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Excel 8.0;HDR=Yes;DATABASE='+@path+''',[sheet1$]) select Darpt_Name,Num_Code,
Name1,sex from BasicInfo_Table where Name1 = '''+@namestring1+''''
字符串的变量需要+'',在动态语句里用'转义一下。