SELECT D.NAME TableName,
STUFF((SELECT ','+A.NAME
FROM SYS.ALL_COLUMNS A
INNER JOIN SYS.TABLES B ON A.OBJECT_ID=B.OBJECT_ID
WHERE B.NAME=D.NAME FOR XML PATH ('')),1,1,'')
FROM SYS.TABLES D
--WHERE D.NAME=@TO_TABLENAME
GROUP BY D.NAME
最终可用于多个表的insert into,而不需要重复写多个inser into。