[In preview] Inline and Table Valued Function support
This request is currently in Preview:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=sqlallproducts-allversions
Currently Functions can only return a single variable, but we need to be able to return full tables so we can use them within the WHERE clause.
Inline Table Valued Functions are currently in Preview. Will be supported in tooling in coming months.
5 comments
-
Anonymous commented
Eagerly loking for this future enabled
ASAP
Thanks
-
Ann commented
Hello Synapse Team - I am trying to use this preview feature but Visual Studio 2019 Preview 16.9.2 does not recognize the functions. Error: SQL70015: Keyword or statement option 'INLINE TABLE VALUED' is not supported for the targeted platform.
Is there a newer preview of Visual Studio planned to support this and if so any date?
-
Ahir, Bhavik commented
Hello Synapse Team, Any update about this feature ?
-
Nguyen, Kelvin commented
Hello Microsoft, any updates on this?
-
Anonymous commented
Hello Azure Synapse Team, any news on when this feature will be available even in preview ?
Thanks