Jim,
Take your anti-anxiety medications, and don't worry. Scott is either
making extra work for himself, or being lazy, depending on your point of
view.
You could also do this:
SET V vVersion = (CVAL('VERSION'))
SHO V vVersion
Scott is using a technique that lets him do it with a single command,
by selecting the "expression" -- and no columns -- from a table that he
knows you have in your database. By the time he adds the WHERE
clause, so that you only see the answer once, it's probably as much
work as the two commands above.
Many developers create a one row, one column table named Dummy to
enable tricks like Scott's.
Bill
On Fri, 21 Sep 2001 16:28:05 -0400, Jim Limburg wrote:
>Where on earth did you learn a command like this...?
>Where is it in the docs?
>
>Someone's holding out on me...
>I,I,I just don't know what to think about how
>deprived I feel right now...
>
>OK, OK,,, I'm settled down now...
>Whew... I still am interested in learning more
>about this...
