It is the same in SQL Server 2005, 2008 and 2012.

If you want to check what the compiled value is you can use this.

create table T(Name varchar(25));

go

create procedure GetIt

@Name varchar(25)

as

set @Name = 'Pelle';

select *

from T

where Name = @Name;

go

exec GetIt 'Kalle';

with xmlnamespaces(default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')

select T.qp.value('(//ColumnReference/@ParameterCompiledValue)[1]', 'varchar(25)') as ParameterCompiledValue

from

(

select cast(qp.query_plan as xml) as qp

from sys.dm_exec_query_stats as qs

cross apply sys.dm_exec_sql_text(qs.sql_handle) as st

cross apply sys.dm_exec_text_query_plan(qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset) as qp

where object_name(st.objectid) = 'GetIt'

) as T;

exec sp_recompile 'T';

exec GetIt 'Urban';

with xmlnamespaces(default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')

select T.qp.value('(//ColumnReference/@ParameterCompiledValue)[1]', 'varchar(25)') as ParameterCompiledValue

from

(

select cast(qp.query_plan as xml) as qp

from sys.dm_exec_query_stats as qs

cross apply sys.dm_exec_sql_text(qs.sql_handle) as st

cross apply sys.dm_exec_text_query_plan(qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset) as qp

where object_name(st.objectid) = 'GetIt'

) as T;