To get current SESSION ID:

select @@spid

To get current TRANSACTION ID:

select CURRENT_TRANSACTION_ID()