Hi,

I want to make a stored procedure where i get all the
colum names from a table.
I know i can use SELECT COL_NAME(OBJECT_ID('Tablename'),1)
But this just gives me the first columname.
And i dont want to use a "while 'ColumName' is not NULL
do..." Loop.
Is there a way to get them all in once?