Articles → SQL SERVER → Set Noexec Statement In SQL Server

Set Noexec Statement In SQL Server

In this article, we will discuss the "set noexec" statement in the SQL server.

Purpose

The "set noexec" statement when "on" compiles the query but it does not execute them.

Example

Consider the following queries: -

Set noexec on

-- This query will not execute as noexec is set to "On"
select top 5 * from sys.procedures

Set noexec off

-- This query will execute as noexec is set to "Off"
select top 5 * from sys.objects

As mentioned above, the first query will not execute because "noexec" is set to "on". The second query will execute because "noexec" is set to "off".

Output

Posted By -	Karan Gupta

Posted On -	Saturday, June 5, 2021

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**