... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 18,536 of 19,505

Travis Crow to Erland Sommarskog

Re: Cursor Question

02 Dec 11 12:03:48

   From: noreply@invalid.org   
      
   On Fri, 02 Dec 2011 12:35:43 +0100, Erland Sommarskog wrote:   
      
   > With a static cursor, the result set of the cursor is saved to a temp   
   > table and the rows are served from this table. I believe this happens at   
   > OPEN time, but you could easily test to find out.   
      
   Thanks. I have tested this and it appears to be at OPEN time.   
      
   --   
   Travis Crow   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]