1. 存储过程
/*
测试简CASE 函数将某个表达式与一组简单表达式进行比较以确定结果,如果输入1,则输出大写的壹.
*/
ALTER PROCEDURE dbo.GetDaXieChar
@value int,
@strout char(2) output
AS
select @strout =
case @value
when 1 then '壹'
else
'N0'
end
RETURN
2. 在查询分析器中进行测试
1.
declare @out char(2)
exec GetDaXieChar @value = 1, @strout = @out output
print(@out)
输出结果为: 壹
2.
declare @out char(2)
exec GetDaXieChar @value = 7, @strout = @out output
print(@out)
输出结果为: no