SET PARSEONLY (TSQL Statement)

parses and compiles the batch, but doesn’t execute it.

Syntax

SET PARSEONLY { ON | OFF }

Remarks

When the option PARSEONLY is ON, the batch is parsed and compiled, but not executed.

This way, you can check if the batch has no syntax error without executing it.

With RSQL, this option is the same as SET NOEXEC.

With MS SQL Server, SET PARSEONLY only parses but doesn’t compile the batch.