I have some queries that are parameterized, but they are still creating a new execution plan each time. I am using SQL Server 2016.
Queries are like:
(@P1 varchar(1043),@P2 varchar(6)) UPDATE table SET FILEDATA=@P1 WHERE FILEID=@P2
This query is not using the already generated execution plan from the cache, rather it is creating a new plan each time.