Home » SQL Server Error : 132 SQL Server Error 132

SQL Server Error : 132 SQL Server Error 132

sql server DBA 999

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 … Read the rest