Methods for Executing Transact SQL cursor in SQL Server

Question

I want to execute Transact SQL cursor in SQL Server 2008, please tell what method I can use to do the same