Skip to content

[FORMATTING] Unable to format SQL: Error: Parse error: Unexpected "@tableVeriable" at line x column y #855

@gmcoates101

Description

@gmcoates101

Input data

Which SQL and options did you provide as input?

DECLARE         @tv TABLE(name VARCHAR(12));

INSERT INTO     @tv
VALUES          ('bob')

SELECT			*
FROM			OtherTable ot
INNER JOIN		@tv t
	ON			ot.Name = t.Name;

Expected Output

No error

Actual Output

Unable to format SQL: Error: Parse error: Unexpected "@tableVeriable" at line x column y

The x and y point to the first @ symbol following the initial DECLARE statement.

Usage

  • How are you calling / using the library?
    VSCode did this automatically.
  • What SQL language(s) does this apply to?
    T-SQL
  • Which SQL Formatter version are you using?
    Identifier inferrinizzard.prettier-sql-vscode
    Version 1.6.0
    Last Updated 2025-04-07, 13:11:03

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions