获取某个表的全部表名，并转换成字符串作比较使用

Select  @CompareCol1 = STUFF((select ',' + COLUMN_name from INFORMATION_SCHEMA.columns where TABLE_NAME = @TableName1
									and COLUMN_NAME not in (''''+ @ExceptCol +'''')
									FOR XML PATH('')), 1, 1, '') 

select STUFF((select ',' + COLUMN_name from INFORMATION_SCHEMA.columns where TABLE_NAME = 'emp'
									and COLUMN_NAME not in (' ')
									FOR XML PATH('')), 1, 1, '')