set-parseonly-transact-sql.md

title	SET PARSEONLY (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	PARSEONLY_TSQL SET_PARSEONLY_TSQL PARSEONLY SET PARSEONLY
dev_langs	TSQL
helpviewer_keywords	parsing [SQL Server], SET PARSEONLY statement checking syntax PARSEONLY option syntax [SQL Server], verifying verifying syntax SET PARSEONLY statement
ms.assetid	514ab042-c53e-4d96-be71-fb08fcc6ef3c
caps.latest.revision	18
author	BYHAM
ms.author	rickbyh
manager	jhubbard

SET PARSEONLY (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

Examines the syntax of each [!INCLUDEtsql] statement and returns any error messages without compiling or executing the statement.

Transact-SQL Syntax Conventions

Syntax

  
SET PARSEONLY { ON | OFF }  

Remarks

When SET PARSEONLY is ON, [!INCLUDEssNoVersion] only parses the statement. When SET PARSEONLY is OFF, [!INCLUDEssNoVersion] compiles and executes the statement.

The setting of SET PARSEONLY is set at parse time and not at execute or run time.

Do not use PARSEONLY in a stored procedure or a trigger. SET PARSEONLY returns offsets if the OFFSETS option is ON and no errors occur.

Permissions

Requires membership in the public role.

See Also

SET Statements (Transact-SQL)
SET OFFSETS (Transact-SQL)