Home » The variable name has already been

The variable name has already been

sql server DBA 999

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

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