USE AdventureWorks2000

declare @TABLE_NAME sysname
declare @TABLE_SCHEMA sysname
declare @sql nvarchar(4000)
declare @table_alias sysname

set @TABLE_NAME = 'Address'
set @TABLE_SCHEMA = 'dbo'
set @table_alias = 'a'
set @sql = ''

select
	@sql = @sql+
	case
	when a.ORDINAL_POSITION = 1
	then 'select'+char(13)+Char(10)
	else ''
	end+
	char(9)+
	@table_alias+'.'+
	quotename(a.COLUMN_NAME)+
	case
	when a.ORDINAL_POSITION = b.LAST_ORDINAL_POSITION
	then ''
	else ',' end+
	char(13)+Char(10)+
	case
	when a.ORDINAL_POSITION = b.LAST_ORDINAL_POSITION
	then	'into'+char(13)+Char(10)+char(9)+'#temp'+char(13)+Char(10)+
		'from'+char(13)+Char(10)+char(9)+
		quotename(@TABLE_SCHEMA)+'.'+quotename(@TABLE_NAME)+' '+@table_alias
	else ''
	end
from
	INFORMATION_SCHEMA.COLUMNS a
	cross join
	(
	select
		LAST_ORDINAL_POSITION = max(bb.ORDINAL_POSITION)
	from
		INFORMATION_SCHEMA.COLUMNS bb
	where
		bb.TABLE_SCHEMA = @TABLE_SCHEMA and
		bb.TABLE_NAME = @TABLE_NAME
	) b
where
	a.TABLE_SCHEMA	= @TABLE_SCHEMA and
	a.TABLE_NAME	= @TABLE_NAME
order by
	a.ORDINAL_POSITION

--exec (@sql)
select [@sql] = @sql