This is the eight post of SET Statement series
when SET FMTONLY set to ON, query will return only metadata to the client. This setting can be used to test the format of the response without actually running the query.
SET FMTONLY ON;
SET FMTONLY OFF;
Output of this is,
So there will be no rows returned.
However, this SET option is set to depreciate with SQL Server 2012.
Previous posts of this series,