Cursors In SQL Server

Declare cursor_name cursor for select_Statement

Open cursor_name

fetch next from cursor_name [into variable_name]

while @@fetchstatus = 0 
begin
   // Do something fetch next 
   from
      cursor_name [into variable_name] 
end

close cursor_name

deallocate cursor_name

Declare @con as varchar(50) 
Declare @temp as varchar(50) 
Set
   @con = '' 
   Set
      @temp = '' 
      Declare mycursor cursor for 
      select
         sName 
      from
         tbl_Test open mycursor fetch next 
      from
         mycursor into @con while @@fetch_status = 0 
         begin
      Set
         @con = @con + @temp fetch next 
      from
         mycursor into @temp 
         end
         close mycursor deallocate mycursor 
         select
            @con  

Query/Feedback