Revision history [back]

@@error, @@rowcount, and other similar variables are server-level variables that are not supported in Synapse Dedicated SQL pool. This is because Synapse Dedicated SQL pool is a distributed data warehouse that processes queries across multiple compute nodes, and these variables only apply to individual query batches on a single node. To work with error handling and row counts in Synapse Dedicated SQL pool, you should use other techniques such as TRY...CATCH blocks and COUNT() functions.