Transact-SQL does not offer a good way to support
constants in your stored procedures or userdefined functions. This means that you either can choose to hardcode your constants or, the more elegant way, define a userdefined function for each "constant" value. To ensure optimal performance, the
schemabinding keyword should be used.
Here is an example:
CREATE FUNCTION [dbo].[sudf_Security_Privilege_User]
(
)
RETURNS INT
with schemabinding
AS
BEGIN
-- Return the access level
RETURN (1);
END
In your stored procedure you can call the function the normal way, i.e.
set x = dbo.sudf_Security_Privilege_User();
