Assume that you have an instance of Microsoft SQL Server 2012 that has SQL Server 2012 Service Pack 1 (SP1) cumulative update 7 or a later version update installed. You execute the system stored procedure sp_describe_undeclared_parameters
, and the stored procedure includes an always FALSE statement in the statement for @tsql
parameter. For example:
sp_describe_undeclared_parameters @tsql= N'SELECT * from testTable where column1 = @p1 AND 1=2'
In this situation, the execution of sp_describe_undeclared_parameters
fails, and you receive the following error message:
Msg 11502, Level 16, State 2, Line 28Note
The type for parameter '@p1' cannot be deduced in this context.
This issue also occurs in SQL Server 2014.