asp调用存储过程问题请教！！！！急！！！！

Question

cmd.ActiveConnection=cn
cmd.CommandText="sp_TotalHandoverForweb_yyc"
cmd.CommandType=4
cmd.parameters(1)=1
cmd.parameters(2)='2003-7-1'
cmd.parameters(3)='2003-7-29'
set rs=cmd.Execute()

Answer 1

if not rs.eof then
while not rs.eof........
end
rs.close
end if

Answer 2

存储过程中最后要把临时表删除掉Create Procedure sp_TotalHandOverForWeb
@Department_id integer,
@StartDate datetime,
@EndDate datetime
With Encryption
as
begin
set nocount on
...............................
drop table #HandOverForWeb
set nocount off
end