<div>
<div class="content wysiwyg-content">
Normally I place TSQL constants in a Parameter table and retrieve them in the procedure. &nbsp;I'm working on a database, however, that belongs to someone else, and I don't have that option. &nbsp;Is it possible to declare a constant in a procedure? &nbsp;
</div>
</div>


Normally I place TSQL constants in a Parameter table and retrieve them in the procedure.  I'm working on a database, however, that belongs to someone else, and I don't have that option.  Is it possible to declare a constant in a procedure?  

TSQL Constants - Do they exist?

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.