Problem Statement:
Hi,
My requirement is if I modify the data type of column in parent table, in Table function also it needs to be updated automatically. Currently depending the data type of parent table we are manually giving the data type(in return table) of a column in table function(i.e nvarchar, nbinary).
Is there any way in table function to pass the data type of a column dynamically based on the parent column datatype.