SQL Code

SQLServerCentral Article

SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values

  • Article

Learn about an alternative strategy for avoiding hardcoded literal values in SQL Server queries by using single-row views designed to mimic enum behavior.

(2)

You rated this post out of 5. Change rating

2026-06-26

3,297 reads

Technical Article

(6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,951 reads

Blogs

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

Finding Gaps in Sequential Data Using SQL Server

By Imran2629

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

Negative and Positive Numbers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Negative and Positive Numbers

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers