Ivica Borscak

I'm a Software Developer with experience in database and backend development (MS SQL Server, PostgreSQL, C#/.NET, etc.).
  • Interests: Databases (MS SQL Server, PostgreSQL, ...), .NET, C#, Software architecture and design, AI

All authors

SQLServerCentral Article

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

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

2,683 reads

All authors

Blogs

Azure – HorizonDB

By

As Open Source – PostgreSQL and AI is a growing and powerful DB system,...

A New Chapter: Why I Made the Move from Dayforce to ESO

By

A New Chapter: Why I Made the Move from Dayforce to ESO Over the...

Lean Six Sigma – Brief

By

When you have a project or system, it has to be optimized, tuned, and...

Read the latest Blogs

Forums

How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning

By Dinesh Asanka

Comments posted to this topic are about the item How Clustering can be Used...

Moving the Error Log

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving the Error Log

A Security and AI Fail

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Security and AI Fail

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers