sqlserver函数 标量值函数

USE [app92]
GO
/****** Object: UserDefinedFunction [dbo].[Func_GetPayChannel] Script Date: 2019/6/26 15:12:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[Func_GetPayChannel](@Channel VARCHAR(40))
RETURNS VARCHAR(300)
AS
BEGIN
DECLARE @ResText VARCHAR(300);
SET @ResText='';
SET @ResText= CASE @Channel
WHEN 'icbcpay' THEN '工商银行'
WHEN 'ccbszauto' THEN '深圳建行'
WHEN 'other' THEN '其他'
WHEN 'blpay' THEN '泊链'
WHEN 'xftpay' THEN '星付通'
WHEN 'alipay' THEN '支付宝'
WHEN 'unionpay' THEN '银联'
WHEN 'ccbpay' THEN '建设银行'
WHEN 'abcpay' THEN '农业银行'
WHEN 'cmbpay' THEN '招商银行'
WHEN 'unline' THEN '线下支付'
WHEN 'weixin' THEN '微信'
END
RETURN @ResText
end

转载于:https://www.cnblogs.com/lshbk/p/11090011.html