How to find error on script using Microsoft.SqlServer.TransactSql.ScriptDom

Question

I have a SQL script X Select top 1 * from table. I use MicrosoftSql.Smo to check script has error or not. The letter X is incorrect for SQL script. But it cannot find the error in the script and evaluates as true. How can I solve this problem. Instead of using GetTokenStream, I also used Parse method. Nothing has been changed.

IList<ParseError> parseErrors;
TSql140Parser tsqlParser = new TSql140Parser(true);
IList<TSqlTokenStream> tStream;
using (StringReader stringReader = new StringReader(script))
            {
                tStream= (TSqlFragment)tsqlParser.GetTokenStream(stringReader, out parseErrors);
            }
if (parseErrors.Count > 0)
{
   var retMessage = string.Empty;
   foreach (var error in parseErrors)
   {
     throw new Exception("error in script")
   }
}
return (TSqlScript)fragment;

Martin Smith · Accepted Answer · 2022-05-20 10:18:16Z

2

This isn't a grammar error.

The script

X Select top 1 * from [table]

is just treated the same as

EXEC X;

Select top 1 * from [table];

SQL Server allows the term EXEC to be omitted in the first statement in a batch so it just interprets it as you trying to execute a stored procedure called X

answered May 20, 2022 at 10:18

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Charlieface Over a year ago

And name deferral means it will only notice at runtime that it doesn't exist...

Collectives™ on Stack Overflow

How to find error on script using Microsoft.SqlServer.TransactSql.ScriptDom

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related