Suggest an idea for a new or improved feature!

← Azure Synapse Analytics

[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.

71 votes

Randy Walker shared this idea · Jan 5, 2016 · Flag idea as inappropriate… · Admin →

started ·

AdminAzure Synapse Team (Admin, Microsoft Azure) responded · May 19, 2020

Inline Table Valued Functions are currently in Preview. Will be supported in tooling in coming months.

Show previous admin responses (4)

5 comments

An error occurred while saving the comment

Anonymous commented · January 27, 2021 6:20 AM · Flag as inappropriate

Eagerly loking for this future enabled

ASAP

Thanks

Submitting...
Ann commented · January 14, 2021 11:42 AM · Flag as inappropriate

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?

Submitting...
Ahir, Bhavik commented · October 8, 2020 10:09 AM · Flag as inappropriate

Hello Synapse Team, Any update about this feature ?

Submitting...
Nguyen, Kelvin commented · September 23, 2020 5:11 AM · Flag as inappropriate

Hello Microsoft, any updates on this?

Submitting...
Anonymous commented · August 17, 2020 8:13 AM · Flag as inappropriate

Hello Azure Synapse Team, any news on when this feature will be available even in preview ?
Thanks

Submitting...

Azure Synapse Analytics: SQL/T-SQL

Searching…

No results.
Clear search results

Give feedback
- (General Feedback) 6,590 ideas
- Additional Services 325 ideas
- Analytics Platform System 20 ideas
- API Apps 0 ideas
- API Management 638 ideas
- Automation 518 ideas
- Azure Active Directory 5,027 ideas
- Azure Active Directory Application Requests 275 ideas
- Azure Advisor 32 ideas
- Azure Analysis Services 187 ideas
- Azure API for FHIR 12 ideas
- Azure App Configuration 44 ideas
- Azure Arc 27 ideas
- Azure Automanage 4 ideas
- Azure Backup 539 ideas
- Azure Blockchain Service 11 ideas
- Azure Bot Service 35 ideas
- Azure Certified Device 15 ideas
- Azure Cloud Shell 364 ideas
- Azure Cognitive Services 43 ideas
- Azure Confidential Compute 1 idea
- Azure Container Instances 165 ideas
- Azure Container Registry 97 ideas
- Azure Cosmos DB 275 ideas
- Azure CycleCloud 5 ideas
- Azure Data Explorer 208 ideas
- Azure Data Share 11 ideas
- Azure Database for MariaDB 18 ideas
- Azure Database for MySQL 72 ideas
- Azure Database for PostgreSQL 155 ideas
- Azure Database Migration Service 78 ideas
- Azure Databricks 270 ideas
- Azure Dev Spaces 10 ideas
- Azure Digital Twins 20 ideas
- Azure Event Grid 65 ideas
- Azure FarmBeats 12 ideas
- Azure Functions 235 ideas
- Azure FXT Edge Filer 0 ideas
- Azure Governance 195 ideas
- Azure HPC Cache 0 ideas
- Azure IoT (Hub, DPS, SDKs) 325 ideas
- Azure IoT Central 152 ideas
- Azure IoT Edge 86 ideas
- Azure IoT Security 0 ideas
- Azure IoT Solution Accelerators 45 ideas
- Azure Key Vault 172 ideas
- Azure Kinect DK 66 ideas
- Azure Kubernetes Service (AKS) 293 ideas
- Azure Lighthouse 30 ideas
- Azure Management Groups 23 ideas
- Azure Maps 74 ideas
- Azure Marketplace 454 ideas
- Azure Media Services 255 ideas
- Azure Migrate 61 ideas
- Azure mobile app 358 ideas
- Azure Monitor 251 ideas
- Azure Monitor- Alert Management 157 ideas
- Azure Monitor-Application Insights 791 ideas
- Azure Monitor-Log Analytics 995 ideas
- Azure NetApp Files (ANF) 31 ideas
- Azure Pack 293 ideas
- Azure portal 2,192 ideas
- Azure Purview 157 ideas
- Azure Quantum 0 ideas
- Azure Red Hat OpenShift 12 ideas
- Azure Remote Rendering 10 ideas
- Azure Reservations 182 ideas
- Azure Resource Manager 554 ideas
- Azure Search 288 ideas
- Azure Security Center 308 ideas
- Azure Sentinel 115 ideas
- Azure Service Health 41 ideas
- Azure SignalR Service 17 ideas
- Azure Spatial Anchors 30 ideas
- Azure Sphere 82 ideas
- Azure Spring Cloud 3 ideas
- Azure Stack HCI 6 ideas
- Azure Stack Hub 202 ideas
- Azure Synapse Analytics 452 ideas
- Azure TCO Calculator 30 ideas
- Azure Time Series Insights 29 ideas
- Batch 36 ideas
- Batch AI 10 ideas
- Biztalk Services 14 ideas
- Blockchain 55 ideas
- Cache 41 ideas
- Change Tracking 12 ideas
- Cloud Services (Web and Worker Role) 272 ideas
- Cost Management 340 ideas
- Cross region move for Azure resources 11 ideas
- Customer Insights 13 ideas
- Customer Lockbox for Microsoft Azure 1 idea
- Data Catalog 178 ideas
- Data Factory 1,212 ideas
- Data Lake 355 ideas
- Data Science VM 24 ideas
- Diagnostics and Monitoring 201 ideas
- Event Hubs 41 ideas
- Global Infrastructure 44 ideas
- HDInsight 133 ideas
- Lab Services 374 ideas
- Logic Apps 1,823 ideas
- Machine Learning 231 ideas
- Mobile Engagement 19 ideas
- Networking 1,431 ideas
- Notification Hubs 36 ideas
- Project Bonsai 29 ideas
- Scheduler 43 ideas
- Scripting and Command Line Tools 102 ideas
- SDK and Tools 148 ideas
- Security and Compliance 104 ideas
- Service Bus 205 ideas
- Service Fabric 304 ideas
- Signup and Billing 1,779 ideas
- Site Recovery 296 ideas
- SQL Data Sync 68 ideas
- SQL Database 877 ideas
- SQL Managed Instance 152 ideas
- SQL Server 10,677 ideas
- SQL Server - Big Data Clusters 47 ideas
- Storage 1,008 ideas
- StorSimple 26 ideas
- Stream Analytics 270 ideas
- Support Feedback 276 ideas
- System Center Data Protection Manager 152 ideas
- Update Management 185 ideas
- Virtual Machines 1,690 ideas
- Web Apps 628 ideas
Microsoft Azure