Use of SQL Server cursors

Give me a chestnut:

--Temp VariableDECLARE @Id uniqueidentifier--declaring a cursor nameDECLARECursor_nameCURSOR  for SELECTId fromCom_datadictionaryinfo--Open CursorOPENcursor_name--the case where the @ @FETCH_STATUS =-1 cannot enter the next cursor loop is first queried once again to prevent multiple cursorsFETCH NEXT  fromCursor_name into @Id--Cyclic data fetching while @ @FETCH_STATUS = 0BEGIN    SELECT @Id    FETCH NEXT  fromCursor_name into @IdEND--Close CursorsClosecursor_name--Delete CursordeallocateCursor_name

However, cursors are less used and inefficient.

Use of SQL Server cursors