SQL中常量的最佳模式?

I have seen several patterns used to 'overcome' the lack of constants in SQL Server, but none of them seem to satisfy both performance and readability / maintainability concerns.I have seen several patterns used to 'overcome'