Here it is :
declare @TableName varchar(max)
set @TableName = 'TableName'
declare @selectstatement varchar(max)
SELECT @selectstatement = ISNULL(@selectstatement, '') + syscolumns.name +','+syscolumns.name +','
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
JOIN systypes ON syscolumns.xtype=systypes.xtype
WHERE sysobjects.xtype='U' and sysobjects.name= @TableName
ORDER BY sysobjects.name,syscolumns.colid
set @selectstatement = 'select '+substring(@selectstatement, 1 , LEN(@selectstatement) -1)+' from '+ @TableName
exec (@selectstatement)
Hope it helps.