CREATE FUNCTION [dbo].[GetDeleteFlagStatus]
(
@DeleteFlag INT
)
RETURNS NVARCHAR(15)
AS
BEGIN
DECLARE @Status NVARCHAR(15);
SET @Status = (CASE WHEN @DeleteFlag=0 THEN 'Active'
WHEN @DeleteFlag=1 THEN 'Suspend'
WHEN @DeleteFlag =2 THEN 'Delete'
END)
RETURN @Status
END
(
@DeleteFlag INT
)
RETURNS NVARCHAR(15)
AS
BEGIN
DECLARE @Status NVARCHAR(15);
SET @Status = (CASE WHEN @DeleteFlag=0 THEN 'Active'
WHEN @DeleteFlag=1 THEN 'Suspend'
WHEN @DeleteFlag =2 THEN 'Delete'
END)
RETURN @Status
END
No comments:
Post a Comment