Forum Discussion

carlton7372's avatar
carlton7372
Icon for Helper III rankHelper III
1 year ago
Solved

Azure Fabric Datawarehouse Unsupported DataType

Hello Community,

 

I getting the following error when I attempt to create a stored procedure using T-SQL used a regular Azure SQL Database:

 

Procedure GetLoad. TYPE 'table' is not supported.

 

The line of code that is causing the error is:

 

DECLARE Nums TABLE (
n INT
);

 

As you can see the issue is 'table' isn't supported in Fabric Datawarehouse.

 

Can someone let me know what the equivalent is in Fabric Datawarehouse?