Azure Synapse SQL does not support the the use of TABLE variable. Therefore a workaround is to use Temporary Tables in SqlDW. If we run the below statement in Synapse SQL then it willa throw syntax error as below: /*Standard use on TABLE Variable*/ DECLARE @tblExclude TABLE ([ColumnName] sysname NOT NULL); Msg 103010, Level 16, … Continue reading SqlDW / Synapse – TABLE Variable Compatibility
Tag: Synapse
The absolute key to getting agility and extensibility in a data warehouse project is a good meta data based automation framework and tools, regardless of whether you are using TSQL, Pool, Databricks and/or Python. If you are coming to SqlBits 2022, then there are a few sessions touching on this subjects. Full Schedule on this … Continue reading Meta data Automation at SqlBits 2022