当具有常量的相同查询返回122K时，为什么使用参数的查询不返回任何行

I'm in SQL Server 2008 and I have been working on making some older code use parameters instead of building the queries using string concatenation. And I'm also working on making things work faster by doing things like adding indexes to tables. I'm in SQL Server 2008 and I have been working