Is there some Sp out there?

select column_name
from information_schema.columns where
table_name = 'tbl1'

tbl1 is the table for which you want to find the list of columns.
Hope this is what you want.
Show quoteHide quote

coke,

Check the view INFORMATION_SCHEMA.COLUMNS.

Example:

use northwind
go

select TABLE_NAME, COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
where TABLE_SCHEMA = 'dbo' and TABLE_NAME = 'Orders'
order by ordinal_position
go


AMB

Show quoteHide quote

Float vs Decimal
Using a trigger for Veritical Partitioning with a calculated table name...
T-SQL- comparing NULLs
How to loop through each row in table?
Joining multiple tables