MSSQL Generate SELECT statement

declare @sql nvarchar (4000), @table_name nvarchar (100)
Set @table_name = ' Tbl_mail_info '------------------the table name, view name, stored procedure, etc. in your library
Set @sql = ' '

Select @[email protected]+ '      , ' +name+ '
' From syscolumns
WHERE id = (select id from sysobjects where [email protected]_name)
ORDER BY Colorder

Set @sql =stuff (@sql, 1,7, ' select ') + ' from ' [email protected]_name

Print @sql

---------------------------------Results
Select Mail_type
      , Mail_subject
      , Mail_body
From Tbl_mail_info

MSSQL Generate SELECT statement