存储过程怎么传递时间参数

存储过程怎样传递时间参数？
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;[email protected]+''',''select*from [[email protected]+'$]'')

INSERT INTO zfry
(xm,sj)
select xm,[email protected]+'
from #qq


'
)

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

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

















------解决方案--------------------

SQL code

ALTER proc [dbo].[export] @xlslj varchar(99),@sheetname varchar(99),@sj datetimeasexec('select*into #qqfrom OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Excel 5.0;HDR=YES;[email protected]+''',''select*from [[email protected]+'$]'')INSERT INTO zfry(xm,sj)select xm,[email protected]+'''from #qq')