Below links would help :
How to Handle Errors and Row Counts in Synapse Stored Procedures
vikranth-0706
285
Reputation points
I'm migrating a stored procedure from a Data Warehouse to Azure Synapse Dedicated SQL pool. The procedure uses @@error and @@rowcount variables, which are not supported in Synapse. Are there alternative ways to achieve the same functionality without these variables?