强制重编译

 

option (recompile)
使用在语句

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

　　

使用在存储过程

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