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: sqldw
Synapse SQL Dedidcated Pools (aka SQLDW) does not support comments in views or procs in the same was as standalone SQL. This is annoying as comments can be very useful with tracking changes and lineage of objects, especially when used in conjunction with Schema Compare tools in Visual Studio. Everyone has seen that incident where … Continue reading Synpase SQL Tip 2 – Comments in Views/Procs