CREATE procedure util_GetColumnNames 
(
	@TableName varchar (100),
	@Delimiter varchar (10) = ',',
	@AsRow bit = 0
)
as

if not exists(select 1 from sys.objects where type = 'U' and Name = @TableName)
	print 'Table does not exist.'
else
	if (@AsRow = 1)
	begin
		declare @cols varchar(2000)

		SELECT  @cols = ISNULL(@cols + @Delimiter + '[' + C.Name + ']',
                         '[' + C.Name + ']')
		FROM sys.objects O
			inner join sys.columns C
			ON O.object_id = C.object_id
		where type = 'U'
		and O.Name = @TableName

		SELECT @cols	
	end 	
	else
		select '[' + C.Name + ']' + @Delimiter
		from sys.objects O
			inner join sys.columns C
			ON O.object_id = C.object_id
		where type = 'U'
		and O.Name = @TableName

create proc print_select_for 
	@table varchar(128)
as
begin
declare @s varchar(max)
set @s=''
select @s=@s+case ordinal_position 
             when 1 then 'select ' 
             else ', ' 
             end+char(13)+'    '+column_name 
from information_schema.columns
where table_name=@table
order by ordinal_position
set @s=@s+char(13)+'from'+char(13)+'    '+@table
print @s
end
go

exec print_select_for 'something'