set-parseonly-transact-sql.md

title	SET PARSEONLY (Transact-SQL)
description	SET PARSEONLY (Transact-SQL)
author	WilliamDAssafMSFT
ms.author	wiassaf
ms.date	11/27/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.technology	t-sql
ms.topic	reference
f1_keywords	PARSEONLY_TSQL SET_PARSEONLY_TSQL PARSEONLY SET PARSEONLY
helpviewer_keywords	parsing [SQL Server], SET PARSEONLY statement checking syntax PARSEONLY option syntax [SQL Server], verifying verifying syntax SET PARSEONLY statement
dev_langs	TSQL
ms.assetid	514ab042-c53e-4d96-be71-fb08fcc6ef3c
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

SET PARSEONLY (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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 }  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)