• Use in stored procedure only. Once you complete your transaction commit it.