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.nameFROM sys.columns a JOIN sys.types b