Why are variables like @@error, @@rowcount, and others not functioning properly in Synapse Dedicated SQL pool?

edit

@@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.