::NPTEAM:: Network Programer Team

-- 전체 테이블 목록 변수에 넣기
declare @TableNames varchar(8000)
 
SELECT top 10 @TableNames = coalesce(@TableNames,'') + name + ', '
FROM sysobjects
WHERE xtype = 'U'
 
SELECT LEFT(  @TableNames, LEN(@TableNames) - 1 ) AS TableNames
 
 
--테이블의 컬럼 목록 변수에 넣기
declare @ColumnNames varchar(8000)
declare @TableName varchar(128)
SET   @TableName  = '_TTFID'
 
SELECT top 10 @ColumnNames = coalesce( @ColumnNames, '' ) + name  + ', '
FROM syscolumns
WHERE id = ( SELECT id FROM sysobjects
       WHERE name =  @TableName )
ORDER BY colid
 
SELECT @TableName AS TableName, LEFT( @ColumnNames, LEN( @ColumnNames ) - 1 ) AS ColumnNames