Explanation/Reference:
Explanation:
The inline table-valued function required for a Stretch Database filter predicate looks like the following
example.
The parameters for the function have to be identifiers for columns from the table.
Schema binding is required to prevent columns that are used by the filter function from being dropped or
altered.
Example:
CREATE FUNCTION dbo.fn_stretchpredicate(@column1 datatype1, @column2 datatype2 [, ...n])
RETURNS TABLE
WITH SCHEMABINDING
AS
RETURN SELECT 1 AS is_eligible
WHERE <predicate>
References: https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/select-rows-to-migrate-by-
using-a-filter-function-stretch-database?view=sql-server-2017