How to enable or disable forced parametrization on Microsoft SQL Server / Azure SQL Database

 

This enables the forced parametrization:

ALTER DATABASE [MyDatabaseName] SET PARAMETERIZATION FORCED

This disables the forced parametrization:

ALTER DATABASE [MyDatabaseName] SET PARAMETERIZATION SIMPLE

Read the Documentation:

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-ver16#syntax