Bug – Synapse SqlPool Language and dates

We found this interesting bug on Dedicated SQL Pool when working with British style language. If you use Dynamic SQL to change the language, then selects on the date fail with a conversion error, but prints work. Weird... An example repro is below DECLARE @sql nvarchar(4000) Declare @StartDate date=convert(date, getdate()) SET @sql = 'SET LANGUAGE … Continue reading Bug – Synapse SqlPool Language and dates

SqlDW / Synapse – TABLE Variable Compatibility

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