Forum Discussion

kkoba's avatar
kkoba
Frequent Visitor
1 year ago
Solved

How to use dynamic SQL in Fabric Warehouse

I want to use dynamic SQL in Fabric Warehouse.   Looking at the docs, it seems that dynamic SQL is supported in Fabric Datawarehouse. https://learn.microsoft.com/ja-jp/sql/relational-databases/sys...
data warehouse
warehouse
  • AndyDDC's avatar
    AndyDDC
    1 year ago

    Hi kkoba set your variable to type NVARCHAR.  NVARCHAR is indeed not supported in table column datatypes, but you can use variables of type NVARCHAR.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi kkoba ,

 

Thanks for the reply from AndyDDC . Your consideration makes sense as an alternative, but if there is a better way, please take it.

 

Did the above suggestions help with your scenario? if that is the case, you can consider accept the helpful suggestions to help others who faced similar requirements.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!