dbo.QBM_FSQIndexColumns

1  create   function dbo.QBM_FSQIndexColumns (@TableOrTypeName varchar(30) , @IndexName varchar(30) , @IncludedColumns bit ) returns nvarchar(max
2)  as begin return( select isnull(String_agg( convert(nvarchar(max), concat(x.name , case x.is_descending_key when 1 then ' desc' else '' end ) )  , ','
3 )  WITHIN GROUP ( ORDER BY x.key_Ordinal, x.index_column_id) , N'') from ( select c.name, ik.key_Ordinal, ik.index_column_id, ik.is_descending_key from
4 (select t1.object_id from sys.objects t1 with (readpast) where t1.name = @TableOrTypeName union all select t2.type_table_object_id from sys.table_types
5 t2 with (readpast) where t2.name = @TableOrTypeName ) as t join sys.indexes i with (readpast) on t.Object_id = i.Object_id and i.name = @Indexname  and
6 i.is_hypothetical = 0  and i.type not in (3,4,5,6) join sys.index_columns ik with (readpast) on i.Object_id = ik.Object_id and i.index_id = ik.index_id
7 and ik.is_included_column = @IncludedColumns join sys.columns c with (readpast) on c.Object_id = t.Object_id and c.Column_id = ik.Column_id where i.is_primary_key
8 = 0 ) as x ) end 
9