Categories: SQL Server

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 procedure.

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

Vamshi B

Share
Published by
Vamshi B

Recent Posts

sql server detected logical consistency based error

Learn about SQL Server detecting logical consistency based issues and how to resolve them.

5 months ago

sql server error 1222

Learn about SQL Server error 1222 and how to resolve the lock request time out…

5 months ago

Microsoft SQL Server 2022 New Features

Discover the new features of Microsoft SQL Server 2022 and how they compare to previous…

5 months ago

SQL Server Error 1222 lock request time out period exceeded

SQL Server Error 1222 lock request time out period exceeded   Lock request time out…

5 months ago

SQL Server Error : 427, Severity: 20. Could not load the definition for constr

SQL Server Error : 427, Severity: 20. Could not load the definition for constraint ID…

10 months ago

SQL Server Error : 204, Severity: 20. Normalization error in node %ls.

SQL Server Error : 204, Severity: 20. Normalization error in node %ls.

10 months ago

This website uses cookies.