获取Sql Server 某个表的所有字段，并以逗号分隔

if exists( select 1 from sysobjects where name = 'fn_get_all_columns')
drop function fn_get_all_columns
go
Create Function fn_get_all_columns (@table_name varchar(50))
returns varchar(max)
as 
begin
declare @rtn varchar(max)
  
select @rtn = case when @rtn is null then name 
else @rtn  +','+ name
end 
from sys.columns
where object_id = object_id(@table_name)
--print @rtn 
return @rtn
end