mssql与mysql差异之四:存储过程

mssql与mysql区别之四:存储过程

mssql：

create PROCEDURE p1(in v INT,out z VARCHAR(100))beginselect @n:=total FROM `month` where total=v;if @n=1 THENselect @n;ELSEselect 'no';END IF;set z = 2;end;call p1(286,@z);select @z;