mssql与mysql差异之二:判断条件语句区别

mssql与mysql区别之二:判断条件语句区别

mssql:

declare @n varchar(100)set @n = 'aaa'select @n = xx.name from xx order by xx.id descprint '最后一个是:'+@nif(@n='a')beginprint '正解'endelsebeginprint '费解'endgo

?

mysql:

create PROCEDURE p1()beginselect @n:=max(total) FROM `month`;IF @n=1 THENselect 'no';ELSEselect @n;END IF;end;