You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure.
How to return the column names from a table in SQL Server ?
Use AdventureWorks2014
GO
exec sp_columns ‘Employee’
How to return the column names from a table in SQL Server ?
