In this post, let us see how to return only column headers in sql server.
Here is an example :
For more information, Refer -
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