What are the steps to be followed to use Cursor? Posted in SQL Interview Questions by Chandrasekhar Raparthi On December 21, 2014. No comments Steps: Declare cursor Open cursor Fetch records Close cursor Deallocate cursor Happy Reading Share this:GooglePinterestEmailTwitterLinkedInFacebook Tags:cursors Related Posts What is the basic difference between DELETE and TRUNCATE commands? DELETE It is a DML command We can use What is the Difference between Temporary tables and Table Variables? My suggestion is go for Table variables when we I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate? Open SSMS — Right click on Database — Tasks Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email.