Forum Discussion
carlton7372
Helper III
1 year agoAzure 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?
Hi
Currently , table variable is restricted . Please, see below similar question thread
Although as an alternate you can create CTE.
1 Reply
- DataGuru412
Resolver I
Hi
Currently , table variable is restricted . Please, see below similar question thread
Although as an alternate you can create CTE.