@@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.
Asked: 2021-08-31 11:00:00 +0000
Seen: 9 times
Last updated: May 20 '21