Parsing declare statements

[perNyfelt]

Are there any plans to support T-SQL declare statements?
Would a pull request to add support for that be welcome?

Actual Behavior

StringBuffer sql = new StringBuffer()
        .append("declare @extractDate date = (select max(dateExtracted) from creditInformation);\n")
        .append("declare @ciTable table (ciId numeric(19,0));\n")
        .append("insert into @ciTable ")
        .append("select surrogateId as ciId\n")
        .append("from creditInformation\n")
        .append("where dateExtracted = @extractDate");

Statements stmt = CCJSqlParserUtil.parseStatements(sql.toString());

Thows:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "declare" <S_IDENTIFIER>

Expected Behavior

should be parsed into 3 statements.

Specifications

• Version:

    <dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>2.1</version>
    </dependency>

• Platform: Windows 10
• Subsystem: Java 8

[wumpz]

Not yet. Do you want to provide a PR? However, the change should not be so difficult. This seems like a variant of SetStatement.

[perNyfelt]

Yes it should be a variant of SetStatement. I'll try to implement it and create a PR...

[perNyfelt]

Turns out to be quite complicated so I'm giving up. The following 5 variations of Declare exists in SQL Server:

DECLARE @find varchar(30);

DECLARE @find varchar(30) = 'Man%';

DECLARE @group nvarchar(50), @sales money;

DECLARE @MyTableVar table(
EmpID int NOT NULL,
OldVacationHours int,
NewVacationHours int,
ModifiedDate datetime);

DECLARE @LocationTVP AS LocationTableType;

[wumpz]

So why are you closing this issue?

[perNyfelt]

Sorry about that. Should have just left this as a comment.

[wumpz]

@perNyfelt Started implementing this feature.

[wumpz]

Could you check it. I implemented all of your test sql types.

[perNyfelt]

Yes, it works fine! Thank you so much!

[wumpz]

You were right. It was only at the first sight similar to set. However thx for using Jsqlparser. Cheers Tobias