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
Author: Deepak Gupta
In CI/CD Azure Synapse Analytics - part 1 we have covered: Setting up git source control in Synapse StudioThe difference in main collaboration and workspace publish branch In this blog we are going to cover: How to create build pipelinesDeploy to Synapse production workspace using DevOps release pipelines Build Pipeline in DevOps Go to you … Continue reading CI/CD For Azure Synapse Analytics – Part 2