Stored Procedures and Return Statement
In a recent interview i was been asked whether stored procedures can have “return” keyword and what type of values it can return. I thought i will note this point here. Stored Procedures can return value. Only a single numeric value can be returned. Consider the following snippet. [code lang="sql"] CREATE PROCEDURE dbo.GetCustomerMaxID () AS ...