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

查询某个表中所有字段

SELECTa.name,b.name,* FROMsys.columns aJOIN sys.types b ON b.user_type_id = a.user_type_id WHEREa.object_id = OBJECT_ID( 'dbo.T_User' )

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

select stuff((select ','+ 'p.'+a.nameFROM sys.columns a    JOIN sys.types b ON b.user_type_id = a.user_type_idWHERE a.object_id = OBJECT_ID('dbo.t_bi_product') for xml path('')),1,1,'') 

字体下载