Parse error at line 7 column 8 - Sonar Cloud Error on T-SQL Script

[Prakash]

Hi

I am facing the below error on my T-SQL Script which is created for Partition Function.

“Parse error at line 7 column 8”

Don’t understand it clearly why it is throwing error in SonarCloud guideline & how to clear this issue. can anyone suggest.

Here is my Model Script:

CREATE PARTITION FUNCTION PartitionFunction_TableName AS RANGE RIGHT FOR VALUES (N’2019-01-01T00:00:00.000’, N’2019-01-04T00:00:00.000’, N’2019-01-07T00:00:00.000’, N’2019-01-10T00:00:00.000’)

[janos (Janos Gyerik)]

Welcome to the community!

@Prakash

Here is my Model Script:

CREATE PARTITION FUNCTION PartitionFunction_TableName AS RANGE RIGHT FOR VALUES (N’2019-01-01T00:00:00.000’, N’2019-01-04T00:00:00.000’, N’2019-01-07T00:00:00.000’, N’2019-01-10T00:00:00.000’)

Just to be clear, do you mean that this line (“CREATE PARTITION …”) is line 7 in your script file?

[Prakash]

Hi

It is a single line script

[pynicolas (Pierre-Yves Nicolas)]

Indeed, our T-SQL parser is unable to parse such syntax.
I created SONARTSQL-261 to track this problem.