스칼라 펑션(scalar function)

스칼라 펑션

ALTER FUNCTION [dbo].[UF_GetCodeMst] (@Code int)
RETURNS varchar(50)
WITH EXECUTE AS CALLER
AS
BEGIN
DECLARE @gCodeName varchar(50)
SELECT @gCodeName = Codename
FROM CodeMst
WHERE Code = @Code
RETURN(@gCodeName)
END;