retrevie internal variable from database

[kozolika]

I have trouble getting a variable out of MSSQL.
I have an SQL command that contains inserts and I declare a variable @ID. I give it a value, and at the end of the command list I put a SELECT @ID. But I get no data when I fetch this result recordset.
The SQL command is executed in transaction and tried to read after committing the transaction.
This script works in SQL Server Management!