... 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,044 of 19,505

Gene Wirchenko to All

Getting the SET ROWCOUNT Value

23 Dec 10 18:35:57

   XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Hello:   
      
        Is there any way to get the SET ROWCOUNT value?   
      
        No, I do not mean @@ROWCOUNT.  Due to this name collision, I have   
   not found an answer in my searching.  What would replace the blanks in   
   the code below if I want to see the results 10 then 0?   
      
             set rowcount 10   
             _____   
             set rowcount 0   
             _____   
      
        Generalise to any SET parameter values.   
      
        Pointers welcome.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

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