SQL Server Error : 132, Severity: 15. The label ‘%.*ls’ has already been decla

SQL Server Error : 132 Details

SQL Server Error: 132
Severity: 15
Event Logged or not: No
Description:
The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.
Severity 15 Description:
Indicates syntax errors in the Transact-SQL command.

Solution:

Make sure the label for variables and tables are unique in a batch or Stored procedure.

Example:

declare one varchar(10)

declare one varchar(40)

SQL Server Error Code and solution summary

SQL Server Error: 132
Severity: 15
Event Logged or not: No
Description:
The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.

Make sure the label for variables and tables are unique in a batch or Stored procedure.