Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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.

74 votes

Randy Walker shared this idea · January 05, 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 06:20 · Flag as inappropriate

Eagerly loking for this future enabled

ASAP

Thanks

Submitting...
Ann commented · January 14, 2021 11:42 · 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 08, 2020 10:09 · Flag as inappropriate

Hello Synapse Team, Any update about this feature ?

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

Hello Microsoft, any updates on this?

Submitting...
Anonymous commented · August 17, 2020 08:13 · 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) 8,135 ideas
- Additional Services 351 ideas
- Analytics Platform System 20 ideas
- API Apps 0 ideas
- API Management 699 ideas
- Automation 542 ideas
- Azure Active Directory 6,151 ideas
- Azure Active Directory Application Requests 297 ideas
- Azure Advisor 38 ideas
- Azure Analysis Services 191 ideas
- Azure API for FHIR 17 ideas
- Azure App Configuration 54 ideas
- Azure Arc 27 ideas
- Azure Automanage 4 ideas
- Azure Backup 750 ideas
- Azure Blockchain Service 12 ideas
- Azure Bot Service 36 ideas
- Azure Certified Device 16 ideas
- Azure Cloud Shell 376 ideas
- Azure Cognitive Services 96 ideas
- Azure Communication Services 36 ideas
- Azure Confidential Compute 1 idea
- Azure Container Instances 180 ideas
- Azure Container Registry 103 ideas
- Azure Cosmos DB 292 ideas
- Azure CycleCloud 6 ideas
- Azure Data Explorer 250 ideas
- Azure Data Share 14 ideas
- Azure Database for MariaDB 19 ideas
- Azure Database for MySQL 78 ideas
- Azure Database for PostgreSQL 175 ideas
- Azure Database Migration Service 85 ideas
- Azure Databricks 334 ideas
- Azure Dev Spaces 11 ideas
- Azure Digital Twins 22 ideas
- Azure Event Grid 72 ideas
- Azure FarmBeats 14 ideas
- Azure Functions 260 ideas
- Azure FXT Edge Filer 1 idea
- Azure Governance 218 ideas
- Azure HPC Cache 0 ideas
- Azure IoT (Hub, DPS, SDKs) 342 ideas
- Azure IoT Central 167 ideas
- Azure IoT Edge 100 ideas
- Azure IoT Security 0 ideas
- Azure IoT Solution Accelerators 46 ideas
- Azure Key Vault 184 ideas
- Azure Kinect DK 72 ideas
- Azure Kubernetes Service (AKS) 331 ideas
- Azure Lighthouse 36 ideas
- Azure Management Groups 24 ideas
- Azure Maps 83 ideas
- Azure Marketplace 466 ideas
- Azure Media Services 266 ideas
- Azure Migrate 86 ideas
- Azure mobile app 377 ideas
- Azure Monitor 276 ideas
- Azure Monitor- Alert Management 166 ideas
- Azure Monitor-Application Insights 843 ideas
- Azure Monitor-Log Analytics 1,029 ideas
- Azure NetApp Files (ANF) 37 ideas
- Azure Object Anchors 0 ideas
- Azure Pack 298 ideas
- Azure Portal 2,306 ideas
- Azure Purview 230 ideas
- Azure Quantum 0 ideas
- Azure Red Hat OpenShift 17 ideas
- Azure Remote Rendering 10 ideas
- Azure Reservations 193 ideas
- Azure Resource Manager 580 ideas
- Azure Search 312 ideas
- Azure Security Center 345 ideas
- Azure Sentinel 149 ideas
- Azure Service Health 48 ideas
- Azure SignalR Service 19 ideas
- Azure Spatial Anchors 32 ideas
- Azure Sphere 81 ideas
- Azure Spring Cloud 3 ideas
- Azure Stack HCI 10 ideas
- Azure Stack Hub 206 ideas
- Azure Synapse Analytics 550 ideas
- Azure TCO Calculator 30 ideas
- Azure Time Series Insights 37 ideas
- Azure Web PubSub service 3 ideas
- Batch 44 ideas
- Batch AI 10 ideas
- Biztalk Services 14 ideas
- Blockchain 57 ideas
- Cache 45 ideas
- Change Tracking 14 ideas
- Cloud Services (Web and Worker Role) 277 ideas
- Cost Management 383 ideas
- Cross region move for Azure resources 11 ideas
- Customer Insights 13 ideas
- Customer Lockbox for Microsoft Azure 1 idea
- Data Catalog 181 ideas
- Data Factory 1,402 ideas
- Data Lake 358 ideas
- Data Science VM 24 ideas
- Diagnostics and Monitoring 206 ideas
- Event Hubs 58 ideas
- Global Infrastructure 44 ideas
- HDInsight 140 ideas
- Lab Services 397 ideas
- Logic Apps 2,022 ideas
- Machine Learning 256 ideas
- Mobile Engagement 19 ideas
- Networking 1,557 ideas
- Notification Hubs 38 ideas
- Project Bonsai 31 ideas
- Scheduler 44 ideas
- Scripting and Command Line Tools 104 ideas
- SDK and Tools 156 ideas
- Security and Compliance 112 ideas
- Service Bus 186 ideas
- Service Fabric 306 ideas
- Signup and Billing 1,832 ideas
- Site Recovery 307 ideas
- SQL Data Sync 70 ideas
- SQL Database 925 ideas
- SQL Managed Instance 163 ideas
- SQL Server 10,955 ideas
- SQL Server - Big Data Clusters 49 ideas
- Storage 1,077 ideas
- StorSimple 26 ideas
- Stream Analytics 276 ideas
- Support Feedback 281 ideas
- System Center Data Protection Manager 152 ideas
- Update Management 192 ideas
- Virtual Machines 1,742 ideas
- Web Apps 732 ideas
Microsoft Azure