Home » SQL Server Error : 134, Severity: 15. The variable name ‘%.*ls’ has already be

SQL Server Error : 134, Severity: 15. The variable name ‘%.*ls’ has already be

sql server DBA 999

SQL Server Error : 134 Details


SQL Server Error: 134
Severity: 15
Event Logged or not: No
Description:
The variable name ‘%.*ls’ has already been declared. Variable 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: 134
Severity: 15
Event Logged or not: No
Description:
The variable name ‘%.*ls’ has already been declared. Variable 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.

Leave a Reply

Your email address will not be published. Required fields are marked *