In my earlier article, I wrote about one of the new system stored procedure sp_describe_undeclared_parameters shipped with SQL Server 2012. This is very handy system stored procedure whenever you need to find undeclared parameters in a SQL query.
I was trying to find undeclared parameters in a query using this system stored procedure and came across with a new error message. I did some research and fixed it.
Let me explain this error in detail :
Message Number: 11508
Severity : 16
Error Message: The undeclared parameter ‘%.*ls’ is used more than once in the batch being analyzed.
In the given below example, I need to search country region name and a portion of a name in First name, Middle Name & Last Name columns of the employee view. So I wrote a query and it works perfectly. Given below is the script.
Once the query is executed
View original post 181 more words