Una query per ricavare i nomi delle colonne della tabella

>serve una query in SQL.

USE AdventureWorks;

/* Soluzione per SQL Server 2000/2005 */
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = N'Person'
AND TABLE_NAME = N'Contact';

/* Output:

COLUMN_NAME
-------------------------
ContactID
NameStyle
Title
FirstName
MiddleName
LastName
Suffix
EmailAddress
EmailPromotion
Phone
PasswordHash
PasswordSalt
AdditionalContactInfo
rowguid
ModifiedDate

(15 row(s) affected)

*/

/* Soluzione per SQL Server 2005 */
SELECT name 
FROM sys.columns
WHERE object_id = OBJECT_ID('Person.Contact');

/* Output:

name
-------------------------
ContactID
NameStyle
Title
FirstName
MiddleName
LastName
Suffix
EmailAddress
EmailPromotion
Phone
PasswordHash
PasswordSalt
AdditionalContactInfo
rowguid
ModifiedDate

(15 row(s) affected)

*/

if exists (select * from sysobjects where  name = N'fn_Colonne') drop function fn_Colonne
go
create function fn_Colonne ( @ObjectID int )
returns varchar(8000)
as
begin
  declare @ElencoColonne varchar(8000),
    @ColName varchar(256)
  
  set  @ElencoColonne = ''
  declare Columns_cursor cursor read_only 
  for   select   name
    from   syscolumns
    where  Id = @ObjectID
    order  by ColOrder
  
  open Columns_cursor
  
  fetch next from Columns_cursor INTO @ColName
  while @@fetch_status <> -1
    begin
      if @@fetch_status <> -2
        begin
    set @ElencoColonne = @ElencoColonne + ltrim(rtrim(@ColName)) + ', '
        end
        fetch next from Columns_cursor into @ColName
    end
  if len(@ElencoColonne) > 1 set @ElencoColonne = left(@ElencoColonne, len(@ElencoColonne) -1)
  close Columns_cursor
  deallocate Columns_cursor
  return @ElencoColonne 
end
go