Add a sql server table-valued function in schema


is there a way to add to the schema a function that has two parameters and returns a dataset based on these parameters?

If not is there another way to have that kind of functionality?

Thanks in advance



You can create a stored procedure that will accept two parameters and return required dataset. this stored procedure can be registered as a table in Schema.