SQLserver 查询某个表中所有字段并用逗号拼接

查询某个表中所有字段

SELECT
	a.name,
	b.name,
	* 
FROM
	sys.columns a
	JOIN sys.types b ON b.user_type_id = a.user_type_id 
WHERE
	a.object_id = OBJECT_ID( 'dbo.T_User' )

查询某个表中所有字段并逗号拼接

select stuff((select ','+ 'p.'+a.name
FROM sys.columns a
    JOIN sys.types b
        ON b.user_type_id =