TSQL - SET FMTONLY ON/OFF - To display only Column headers (Empty resultset)

In this post, let us see how to return only column headers in sql server.

Here is an example :

--Sample data
DECLARE @Temp TABLE (Id INT,Name VARCHAR(50),DOJ VARCHAR(25))
INSERT @Temp SELECT 1,'Sathya','1-1-2011'
INSERT @Temp SELECT 2,'Deepak','2-1-2010'
SELECT * FROM @Temp

--To display only column headers 
SET FMTONLY ON
SELECT * FROM @Temp

--To display column headers with data rows(normal behaviour)
SET FMTONLY OFF
SELECT * FROM @Temp

 


For more information, Refer - 

• http://technet.microsoft.com/en-us/library/ms173839.aspx 
• http://blogs.msdn.com/b/youngjoo/archive/2006/04/17/577920.aspx 

See Also:

• My posts on T-SQL