Finding number of columns returned by a query.

select top 0 *
into temp_table
from employee_master;

select count(*) as 'No of Columns'
from Information_Schema.Columns c
where table_name = 'temp_table'