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


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’)

Welcome to the community!

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


It is a single line script

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