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’
Subscribe to Blog via Email
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
