存储过程怎样传递时间参数？

[rgn]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER proc [dbo].[export] @xlslj varchar(99),@sheetname varchar(99),@sj datetime
as
exec('
select*into #qq
from OPENROWSET
(''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@xlslj+''',''select*from ['+@sheetname+'$]'')

INSERT INTO zfry
(xm,sj)
select xm,'+@sj+'
from #qq


'
)

exec exportzf 'e:\abc.xls','abc','2012-7-1'

提示语法错误，如果存储过程把时间参数去掉，就能执行，该怎样传递时间参数

[SQL77]

ALTER proc [dbo].[export] @xlslj varchar(99),@sheetname varchar(99),@sj datetime
as
exec('
select*into #qq
from OPENROWSET
(''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@xlslj+''',''select*from ['+@sheetname+'$]'')

INSERT INTO zfry
(xm,sj)
select xm,'''+@sj+'''
from #qq

'
)

[以学习为目的]

INSERT INTO zfry
(xm,sj)
select xm,'+@sj+'--'"+@sj+"'
from #qq

[百年树人]

ALTER proc [dbo].[export] @xlslj varchar(99),@sheetname varchar(99),@sj datetime
as
declare @sql varchar(8000)
set @sql= '
INSERT INTO zfry(xm,sj)
SELECT xm,'''+CONVERT(VARCHAR(10),@sj,120)+'''
from OPENROWSET
(''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;DATABASE='+@xlslj+''',''select*from ['+@sheetname+'$]'')
'
exec (@sql)
GO