use opt;
go
dbcc freeproccache;
go
create proc p1 @b int
as
select * from t1 join t2 on t1.a = t2.b where t1.b = @b option(recompile);
go
exec p1 1
go
select * from 
	sys.dm_exec_cached_plans cp 
	cross apply sys.dm_exec_query_plan(cp.plan_handle) qp
	cross apply sys.dm_exec_sql_text(cp.plan_handle) t
where 
	qp.objectid = object_id('p1')
;
go
exec p1 null
go
select * from 
	sys.dm_exec_cached_plans cp 
	cross apply sys.dm_exec_query_plan(cp.plan_handle) qp
	cross apply sys.dm_exec_sql_text(cp.plan_handle) t
where 
	qp.objectid = object_id('p1')
;
go