SQLServer强制重编译执行计划

sql语句中

select * from Student where id =1 option (recompile)

存储过程中

create proc proc_test  (@i int) with recompile
as   
select * from Area where AreaID = @i