获取字段名

ALTER function [dbo].[获取字段名](@字段名 varchar(max))
returns varchar(max)
as
begin
declare @colname varchar(max)
select @colname=coalesce(@colname +',','') +b.name from sysobjects a join syscolumns b on a.id=b.id where a.id=object_id(@字段名) order by b.colorder
return @colname
end