Coding Magic Values

Question

Post reply

Coding Magic Values

Steve Jones - SSC Editor

SSC Guru

Points: 734459
More actions
February 4, 2023 at 12:00 am

#4144440

Comments posted to this topic are about the item Coding Magic Values

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

skeleton567 SSCertifiable Points: 5672 More actions · Answer 1

I wonder why it's called a 'variable'.

Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )

José Cano SSC Enthusiast Points: 104 More actions · Answer 2

Hello!

I think that since we are in 2023 and the text references 2022, it will be better to use a variable in the text to read the year from the system and avoid the confusion.

Enjoying the content of SSC since a while...

Regards,

José Cano

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 3

Lol, not sure that's the place for a variable. Silly me still in the habit of typing 2022.

It's fixed.

Eric M Russell SSC Guru Points: 125522 More actions · Answer 4

A useful feature would be declaration of user defined global constants at the server or database level.

For example:

DECLARE CONST @@PI NUMERIC(12,10) = 3.1415926535;
DECLARE CONST @@StatusInProcess TINYINT = 2;
DECLARE CONST @@StatusDelivered TINYINT = 3;
DECLARE CONST @@GB BIGINT = 1073741824;

You can kind of do this using scalar functions, but that can potentially have adverse effects on query execution plans.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho