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
Category: SQL Server
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