Advantage Of Cursor In Sql Server

Question

Hi friends I want to know what is cursor ? and what is advantage in sql server with example.

Satyapriya Nayak · Answer

Hi Ajay Cursors allow row-by-row prcessing of the resultsets. Types of cursors: Static Dynamic Forward-only Keyset-driven. See books online for more information. Advantages of cursors:- Row by Row operations can be successfully executed Disadvantages of cursors: Each time you fetch a row from the cursor it results in a network roundtrip where as a normal SELECT query makes only one rowundtrip however large the resultset is. Cursors are also costly because they require more resources and temporary storage (results in more IO operations). Furthere there are restrictions on the SELECT statements that can be used with some types of cursors. Most of the times set based operations can be used instead of cursors. Please refer the below link for the example of Types of cursors http://www.dotnet-tricks.com/Tutorial/sqlserver?id=RLID060512&title=SQL%20Server%20-%20Types%20of%20Cursors Thanks