Limitations of Store Procedure in MS Fabric Warehouse

[Humayun4312]

I am exploring store procedures in MS Fabric Warehouse and notice some functionality is not available. For example return statement and random function. 

Has any one use store procedures in MS Fabric for clients. What issues you have faced in moving from SQL Server to Fabric Warehouse specially store procedures.

[Humayun4312]

Thanks @AndyDDC

I will keep visting this page time to time to see if new information added in it regarding TSQL capabilities in MS Fabric.

[v-cboorla-msft]

Hi @Humayun4312 

Please refer to this link for limitations in Fabric Warehouse: 
https://learn.microsoft.com/en-us/fabric/data-warehouse/limitations
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-query-editor

For additional information please refer : Migrating Azure Synapse Dedicated SQL to Microsoft Fabric (dataroots.io)

Hope this helps. Please let us know if you have any further queries.

Thank you.

[v-cboorla-msft]

Hi @Humayun4312 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[Humayun4312]

The article links shared in this thread are helpful.

I am posting some limitations that I found for my particular case and that people migrating from SQL Server to Fabric Warehouse need to keep in view:

1. Nvarchar and DateTime datatype are not available in MS Fabric. Instead we have Varchar and DateTime2.
2. Column names in SQL query in MS Fabric are case sensitive.
3. Trunacte table statement is not supported.
4. Temporary tables are not supported.

[v-cboorla-msft]

Hi @Humayun4312 

Glad that your query got resolved and you were able to find some insights. Thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

Thank you.

[AndyDDC · Accepted solution]

Hi @Humayun4312 it's worth checking the T-SQL limitations for Fabric Warehouses here https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area