Some SQL server syntax does not support parsing

[SconyHui]

Hi,
I found it unsupported when parsing part of SQLServer syntax.
example:
1, select [id],[name],[age] from [Student]
Because the column name contains the special symbol "[" or "]"
2, declare @Flag int
set @Flag = 1
Because the column name contains the special symbol "@" in SetStatement
3, begin
...
end
This syntax is not supported
4, use LibName
go
...
go
This syntax is not supported

[manticore-projects]

Greetings.

Please use the latest JSQLParser 4.5 or better JSQLParser 4.6 Snapshot since all the Syntax are supported.
Please refer to https://manticore-projects.com/JSQLParser/usage.html#define-the-parser-features for activation of T-SQL Squared Bracket Quotation.

If you still face challenges, then please provide the specific query, shortened/simplified as much as possible.

[SconyHui]

Yes, I'm using version 4.6

[SconyHui]

eg：
select [id],[name],[age] from [Student]

[manticore-projects]

Please activate SquaredBracket Quotation.

[manticore-projects]

select [id],[name],[age] from [Student]

You can test it online here.

[SconyHui]

Thank you. I'll try

[SconyHui]

Thank you. The question has been solved
But I also have problems using this syntax

[manticore-projects]

SET @localVariable is likely not supported.

You would either need to contribute a PR or sponsor the implementation.

[SconyHui]

I will apply to the company

[SconyHui]

Hi,
Is the combination of BEGIIN END and IF not supported

[manticore-projects]

Greetings.

Please refer to https://manticore-projects.com/JSQLParser/_static/JSqlParserCC.xhtml#Block

1. Begin End Blocks of statements are supported

2. IF ELSE Statements are supported

However, your example of IF ELSE with BLOCK is not supported.
It would depend on a major rewrite and/or refactoring since those constructs are MS SQL Server specific.

[SconyHui]

Thank you very much. I will find another way to solve this problem

[manticore-projects]

I will provide a correction and improvement in the evening. On 6 Dec 2022 07:32, SconyHui ***@***.***> wrote: Thank you very much. I will find another way to solve this problem —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: ***@***.***>

[wumpz]

@manticore-projects Did he sponsor the set improvement?

[manticore-projects]

@manticore-projects Did he sponsor the set improvement?

No. :(
But I have to parse some MS SQL Server scripts for myself and so I did not mind.