SQL Interaction and @@ROWCOUNT

The following code works for me:

          exec sql delete Identity_Nummer

                    where Nummer = 0

          end-exec

          declare  rowCount as binary-long.

          exec sql select @@rowcount

                     into :rowCount

          end-exec.

Thanks for your response.

Your code does work however in an OLTP type environment there is a reasonable chance that @@ROWCOUNT will have been reset by another interaction that has occurred between the time of the deletion and you submitting the query to retrieve it.

I believe that SQL Server maintains a separate @@ROWCOUNT for each Connection/transaction. I checked this with 2 SQL queries.

Thanks for your response I will give this a try and see whether it all works.