Parse only statement in SQL Server

When we are writing the script and running this batch scrip. There are three steps to running a batch:

Ø  Parse

Ø  Compile

Ø  Execute

Parse only is use to validate the syntax of the batch. If we only want to check the syntax of the query, we can use the SET PARSEONLY ON statement. When it is ON, SQL Server will only parse the statements (they will not be compiled and executed). SQL Server will verify whether the code consists of valid T-SQL statements.