set ansi_padding, ansi_nulls on;
go

use master;
create database TestParameterization;
alter database TestParameterization set parameterization forced;
go

use TestParameterization;
go

create table dbo.DummyTable (a int not null primary key, b int not null, c float not null);
go

insert into dbo.DummyTable (a, b, c) values (1, 2, 3.0);
go

insert into dbo.DummyTable (a, b, c) values (4, 5, 56.003);
go

insert into dbo.DummyTable (a, b, c) values (7, 8, 9000.0001);
go

select
 cp.*, t.text
from
 sys.dm_exec_cached_plans cp cross apply
 sys.dm_exec_sql_text(cp.plan_handle) t
where
 t.text not like '%sys.dm_exec_cached_plans%' and
 t.text like '%DummyTable%';
go
  
use master;
alter database TestParameterization set single_user with rollback immediate;
drop database TestParameterization;
go

set ansi_padding, ansi_nulls on;
go

use master;
create database TestParameterization;
alter database TestParameterization set parameterization forced;
go

use TestParameterization;
go

create table dbo.DummyTable (a int not null primary key, b int not null, c float not null);
go

insert into dbo.DummyTable (a, b, c) values (1, 2, '3.0');
go

insert into dbo.DummyTable (a, b, c) values (4, 5, '56.003');
go

insert into dbo.DummyTable (a, b, c) values (7, 8, '9000.0001');
go

select
 cp.*, t.text
from
 sys.dm_exec_cached_plans cp cross apply
 sys.dm_exec_sql_text(cp.plan_handle) t
where
 t.text not like '%sys.dm_exec_cached_plans%' and
 t.text like '%DummyTable%';
go
  
use master;
alter database TestParameterization set single_user with rollback immediate;
drop database TestParameterization;
go

set ansi_padding, ansi_nulls on;
go

use master;
create database TestParameterization;
alter database TestParameterization set parameterization forced;
go

use TestParameterization;
go

create table dbo.DummyTable (a int not null primary key, b int not null, c float not null);
go

insert into dbo.DummyTable (a, b, c) values (1, 2, 3e0);
go

insert into dbo.DummyTable (a, b, c) values (4, 5, 56.003e0);
go

insert into dbo.DummyTable (a, b, c) values (7, 8, 9000.0001e0);
go

select
 cp.*, t.text
from
 sys.dm_exec_cached_plans cp cross apply
 sys.dm_exec_sql_text(cp.plan_handle) t
where
 t.text not like '%sys.dm_exec_cached_plans%' and
 t.text like '%DummyTable%';
go
  
use master;
alter database TestParameterization set single_user with rollback immediate;
drop database TestParameterization;
go