Getting the SET ROWCOUNT Value

Giganews Newsgroups
Subject: Getting the SET ROWCOUNT Value
Posted by:  Gene Wirchenko (gen…
Date: Thu, 23 Dec 2010


    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.


Gene Wirchenko