Getting the SET ROWCOUNT Value

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

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

Replies