Friday, April 27, 2012

SET FMTONLY Explanation

SET FMTONLY -- Returns only Column Information to client, not the actual result set.

- It helps to view the format how result is going to display without executing the query.

SET FMTONLY ON;
GO
SELECT * FROM KalyanDB.Employee;
GO
SET FMTONLY OFF;
GO
 
 

No comments: