摘要:
看到RETURN的返回值不同,代表意义各不同,能过查找,得出以下结论:RETURN语句会导致过程立即退出。考察下面的例子:CREATE PROCEDURE check_tables(@who VARCHAR(30))ASIF EXISTS(SELECT name FROM Philosophers WHEREname=@who)BEGINPRINT“In the Philosophers Table”RETURNENDIF EXISTS(SELECT author_name FROM Authors WHEREauthor_name=@who)BEGINPRINT“In the Authors 阅读全文