August 1, 2003 at 2:46 pm
Can anyone breifly explain what this setting is for as well as setting the "=" to value of 9999 in SQL Server 2000.
Setting in question : rec_prec = 9999
TIA
sartre144
August 4, 2003 at 12:28 am
Hi sartre144,
quote:
Can anyone breifly explain what this setting is for as well as setting the "=" to value of 9999 in SQL Server 2000.Setting in question : rec_prec = 9999
in what connection do you use this ?
In most cases you use the '=' to assign some value to a variable. As in your case some numeric value to rec_prec.
Another thought could be the 9999 is used as a max value for something so you don't have to worry about not to catch everything.
Or to set it to some preinitialized valid value, so your code will run error-free.
Cheers,
Frank
Edited by - a5xo3z1 on 08/04/2003 12:46:49 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
August 5, 2003 at 8:18 am
Frank,
Thanks for the feedback...it helped
It was also expalined to me as follows:
Whne you code a total or summary line in a table. If the rec_prec has detailed values, 9999 would be used to show one line of
information for performance puposes.
Thanks,
Andrew
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply