create procedure funWendu
@Temperature int,
@qiwen varchar(10) output
as
begin
if @Temperature in (25,26,27)
set @qiwen='常温'
else if @Temperature in (23,24)
set @qiwen='ä½æ¸©'
else if @Temperature in (28,29)
set @qiwen='é«æ¸©'
else
set @qiwen='温度ä¸æ£å¸¸'
end
--è°ç¨
Declare @qiwen varchar(10)
exec funWendu 27,@qiwen output
print @qiwen
追é®ä¸æ¯è¿ä¸ªææ ä¸é¢çè§åå符串ä¸æ¯åºå®ç æ¯å¨æç
追çä¸æ¯å¾æä½ çææ ãè½è¯´æ¸
æ¥ç¹åï¼ ä¸é¢é£ä¸ªè§åå符串ä¸æ¯åºå®çã
追é®å·²ç»èªå·±è§£å³äº 3q