How to identify open transactions in SQL Server

There are many ways to find open transaction which is not COMMIT or ROLLBACK.

Below script may help you to find out open TRANSACTION in SQL Server
1- Using  SYS.SYSPROCESSES 
SELECT * FROM SYS.SYSPROCESSES WHERE OPEN_TRAN = 1

2- Using  SYS.DM_TRAN_SESSION_TRANSACTIONS
SELECT * FROM SYS.DM_TRAN_SESSION_TRANSACTIONS

PostgreSQL-Query: Sort result set by specific field values using ORDER BY Clause

Problem: Suppose we have a book_inventory table which has some columns such as id, isbn, title, author, publisher, publish_date, etc.. whe...